Hi, I’m trying to assign a value of a column in table type variable which holds data in the typical list format. Is it possible to assign this value to a recorder variable of list type? Is this doable?
E.g. My table variable looks like this
[[‘john’, ‘john@email.com’, ‘male’, [‘reading’, ‘music’]], [‘jack’, ‘jack@email.com’, ‘male’, [‘trecking’, ‘adventure’]], [‘jill’, ‘jill@email.com’, ‘female’, [‘driving’, ‘horse riding’]]]
4 columns namely,
name, email, gender, hobbies
and hobbies holds the data in the list format which I need to get into a list variable to be able to iterate through.
Is this doable? if not then what is the workaround?