Need help on macro

Question

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

template.xlsx

gii_2019_tables-145.txt

umairah · Answer

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

seinchyiwoo · Answer

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

New Workflow1.yxzp