Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamically delimiting data but not using analytical app

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

2 REPLIES 2
binuacs
20 - Arcturus

@ersiddharthsingh1412 it is possible with batch macro, sample attached

image.png

Thanks a ton ... Such a simple solution

Labels