Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Need help on macro

umairah
8 - Asteroid

Hi,

 

I’m creating a macro that read multiple text file and I find it quite challenging as I’m still new in Alteryx. Attached file is the sample text that I need to separate according to the template(attached). I can’t figure out the logic how to come out with same result. I tried using the multi-row tool and formula tool but got stuck.

 

Any guidance is really appreciated.

 

Regards,

Umairah

2 REPLIES 2
seinchyiwoo
Alteryx Alumni (Retired)

Hey Umairah,

 

I have to say this is not a straightforward problem.

I created a workflow specifically for the txt file that you have attached that creates exactly the output that you are looking at - with the use of many multi-row formulas.

Not too sure if other txt files have the same structure but if they are not, then it's gonna be problematic :S

Anyway hope the attached workflow helps to give you an idea on how to parse the data out though.

 

Cheers,

Seinchyi

umairah
8 - Asteroid

Hi @seinchyiwoo,

 

Thank you for the response and I take a look at the workflow and it indeed display the result. It is already problematic because my other text file is in different structure and I need to figure ways to work around with the other text file. But thanks for the help and idea.

 

Regards,

Umairah

Labels
Top Solution Authors