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.