Convert Data table from Read CSV to Array of string

Hi!

Can someone tell me how to convert data table that came from read csv activity to array?

The situation is I have a csv file with multiple columns I read the data using the read csv activity and saved it in data table and I want to convert it. Is that possible?

Thanks!

Hi @alvin.c.apostol26,

You can loop it with the columns using for each row activity and in that loop , you will get the each value and you can use the array.Insert to form an array.

@alvin.c.apostol26,

  1. Use Read Range activity to read data from CSV and will give output as DataTable.

  2. Then iterate it using For Each Row activity.

    Declare one List Variable and Use Add to collection activity to add to that list.
    Here, item is row(“columnname”).toString

1 Like

Hi Guys Thank you for time in responding on my question.

Do you have a sample workflow that I can use as basis?

I’ll appreciate the help

Thanks

Can you provide your sample csv file?

@alvin.c.apostol26,

Please find the attached workflow. If you have any doubts then pls let me know.

CSV_Test.xaml (9.5 KB)

1 Like