Dynamically delimiting data but not using analytical app

[ersiddharthsingh1412]

Hi Everyone,

I hope you're doing good!

I have a query in which I need your help. I am creating a workflow where I am defining all inputs, filters and output locations in an excel file where a user can input all the details and then this file is linked to the alteryx workflow using which the workflow will perform a task 

The problem is input file have different delimiters let's say sometime a comma or pipe. Is there a way that if I mention delimiters in the Excel file with the input path, alteryx pics that up and delimit data accordingly?

Thanks

Siddharth

[binuacs · Accepted solution]

@ersiddharthsingh1412 it is possible with batch macro, sample attached

[ersiddharthsingh1412]

Thanks a ton ... Such a simple solution