Error on using Generate DataTable Activity

Hey, I am trying to use the activity Generate Data Table to split the value from my CSV based on the character “_”. But I am getting this error :

This is a bit on the workflow that I am working on:

Inside the Generate Data Table Activity:

Scenario: I need to divide a column in excel into 5 different columns based on the character “_”
Example Cell Value: ABC_234_TYYU_P_JKL

They are not fixed number of characters and hence need to use a dynamic method.

The output I am getting if I pass a file name to the input of Generate Table Table:

Please advice.


Can you try Read Text File Activity instead of Read CSV activity?


Thank you so much it worked!
Have a great day!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.