Output/Transform a file to an irregular layout

[cicili55]

Hi, 

I have an organized dataset below, but I am asked to transform them into a random template and save each one in a separate sheet. Is it doable using Alteryx? Attached the required output layout. 

Emplid	Name	Income	FTC	Tax	EE FIT	EE SIT	EE SSA	EE MED
1405	ABC	100	50	65	60	0	46	64
1411	DEF	841	0	434	300	0	46	64
131	GHI	7954	241	579	751	8	49	13

Thank you!

[Yoshiro_Fujimori]

Hi @cicili55 ,

I just responded to a similar question (to put values to specific ranges on Excel sheet).

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formatting-data-into-a-excel-f...

I hope this helps your case too.

Good luck.

[cicili55]

Thanks @Yoshiro_Fujimori! I first split my original input file into separate sheets by Name. Then I took the first sheet as my new input and followed your steps. 

The output was formatted nicely in the template so it works! However, the output sheet name is set up as Sheet1 and I could not get it updated to ABC. Also how can I run this across all the sheets in my input file?

Appreciate your guidance!

[KManoj]

Yes, It is doable by splitting the file.