Extract data from 2nd column of table

Help Studio
1

Hi Team,

I need to split the data from 2nd column named “Item” of mytable but the challenge i am facing is that because it is highly dynamic and separated by new line so 1st row data after split is coming as second one .
Can anyone please provide me the logic on how it cane be done.

image
image703×345 59.6 KB

So “Item” column values needs to be stored in variable one by one.

1 Like
2

Hi @som17 As per my understanding you need the entire “Item” column as a seperate datatable means then go for below

Use Assign and datatype should be datatable.

DT2=yourdatatable.Defaultview.totable(True,“Specify your columnname”)

3

is this from excel??
or from any website??
@som17