Create separate files from a Master excel file for each rows

georgechacko

Hi All,

I have a Master File abc.xlsx with sample data given below:

Name     Age    Mark1      Mark2   Mark3      Total

a              19      50             60         70          180

b              18      80             40         50          170

c              19      70             60         60          190

I have to create 3 files like given below

1. File Name a.xlsx

Sheet Contents:

Name     a

Age      19

Mark1   50

Mark2   60

Mark3   70

2. File Name b.xlsx

Sheet Contents:

Name     b

Age      18

Mark1   80

Mark2   40

Mark3   50

3. File Name c.xlsx

Sheet Contents:

Name     c

Age      19

Mark1   70

Mark2   60

Mark3   60

Appreciate for any help with an Alteryx workflow.

Thanks in advance

Regards,

George

kelly_gilbert

Hi, @georgechacko - you can accomplish this with the Transpose tool, then by grouping your output in the Output Data tool.

First, use a Formula tool to generate a custom file name for each Name.

Next, use the Transpose tool to transpose the columns into rows, grouping by the output_file name.

Finally, use the Output Data tool to output to Excel, taking the filename from the field you created. This will group all of the "File Name a" rows into one file, all of the "File Name b" rows into another file, etc.

(Note, in the future it would be helpful if you could attach the sample Excel file to your message. You can also attach the Alteryx workflow to show us what you have already tried!)

Output Excel file by name - 2021-08-11.yxmd