Converting CSV Text to DataTable question

[A_Learner]

Hi,

Is there a way to generate data table using CSV text other than using Generate Data Table? For Generate Data Table I am providing the CSV text and getting DataTable.
When I cannot use Generate Data Table, what are my alternatives?

[SenzoD (Senzo Dlomo)]

Hi there,

What is your reason for not wanting to use generate datatable?

also if possible, can you share a screenshot or a file of the sample delimited text you are working with.

[ppr (Peter Preuss)]

@A_Learner

generate data table using CSV text

Read CSV File was checked?

Activities - Read CSV

[postwick (Paul Ostwick)]

@A_Learner

When I cannot use Generate Data Table

You can always use Generate Data Table to convert CSV text to a datatable.

[Anil_G (Anil Gorthi)]

@A_Learner

1. Directly use read csv
2. If not manually split the data on newline and loop on it using for each and inside the loop split on comma again and send it in row array field of add data row activity…

Cheers

[A_Learner]

Thank you.
Read CSV needs a text file. What I have is a line of text as CSV including headers and data.

[Anil_G (Anil Gorthi)]

@A_Learner

Then you can go with second approach

cheers

[A_Learner]

Gets hard when how many columns are there is unknown.
Thank you,

[Anil_G (Anil Gorthi)]

@A_Learner

Then simply use generate dtataable

Cheers