Pivot data in runtime while generating output

[GayatriPanigrahi]

Hi Team,

Need to generate files based on Approver name and columns for each approver is based on currency which has different records for approver. How to convert the rows to columns while generating files based on column name ?

Below you can find the sample input and output data.

Input :

Group Name	Approver	Currency	Value
CANADA TAX	A	CAD	10
CANADA TAX	A	USD	20
INVESTMENTS	B	USD	-50
OTHER PAYABLES	C	AUD	-18
OTHER PAYABLES	C	HKD	-32
OTHER PAYABLES AT WORK	C	USD	14

Output:

Generate File A.xlsx

Group Name	CAD	USD
CANADA TAX	10	20

Generate File B.xlsx

Group Name	USD
INVESTMENTS	-50

Generate File C.xlsx

Group Name	AUD	HKD	USD
OTHER PAYABLES	-18	-32	0
OTHER PAYABLES AT WORK	0	0	14

[BRRLL99]

Hi

Please check this

This exactly matches your requirement

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-store-the-data-into-multiple-fi...

[binuacs · Accepted solution]

@GayatriPanigrahi One way of doing this with the batch macro