Can I transform an .xlsx file into a .txt file with a specific pattern?

Stanislaw

Hello guys,

Could you please help me with this?

Let's say I have an Excel table like this:

Date	Tea	Coffee
2020M11	36	11
2020M12	33	16

And I would like to create a txt output file that would look this way:

START_SERIES;

NAME: Tea;

DATE: 2020M11 # VALUE: 36

DATE: 2020M12 # VALUE: 33

END_SERIES;

START_SERIES;

NAME: Coffee;

DATE: 2020M11 # VALUE: 11

DATE: 2020M12 # VALUE: 16

END_SERIES;

Is it possible with Alteryx?

Thank you!

Output.txt

afv2688

Hello @Stanislaw ,

I've created a little batch macro that does the job 🙂

If you need anything else let me know

Regards

report_wf.yxzp