Alteryx output into different output files using macro

Hey Community, I have built an Alteryx workflow and workflow resulted in output called Master Data, now I have to create a Macro in such a way that if we give the file name say (Data 1 Output) then columns from Master Data should flow into respective fields available in Data 1 output, if I wanted to choose Data 3 Output then Respective data fields from master data should flow into Data 3 output. any leads please help me.

Snip.PNG

Output

Macros

Iterative Macro

Accepted answers

vinayvnn

@Qiu Thanks very much for your help, output is as expected

All comments

Qiu

@vinayvnn
Can your provide a sample input file and output?

vinayvnn

Hi @Qiu, Thanks for your response.

I have already attached sample output on the post, and you can notice the output data under Master Data.

for your reference am attaching sample output below:

Master Data.PNG

Qiu

@vinayvnn
I mean in data format..😁
not picture...

vinayvnn

@Qiu Apologies for the inconvenience.

Please see the output below:

Master Data Output:

Master Data
Sno	First Name	Last name	Geo Code	Reported Country	Country	Collection Period	Current Status	Date Received
1	Vin	wee	101	CN	India	Jun -Oct	Yes	1st Oct
2	sup	qee	102	IN	London	Jun -Oct	No	1st Oct
3	nvv	ree	103	KN	UK	Jun -Oct	Yes	1st Oct
4	knn	tee	104	LN	USA	Jun -Oct	Yes	1st Oct
5	enn	yeee	105	AN	Sweeden	J un -Oct	Yes	1st Oct
6	fnn	uee	106	QN	Poland	Jun -Oct	Yes	1st Oct
7	gnn	iee	107	IN	UK	Jun -Oct	Yes	1st Oct
8	hnn	oee	108	MN	USA	Jan-Dec	Yes	1st Jan
9	amm	pee	109	GN	Sweeden	Jan-Dec	Yes	2nd Jan
10	snn	see	110	EN	Poland	Jan-Dec	Yes	3rd Jan
11	knn	aee	111	QN	India	Jan-Dec	Yes	4th Jan
12	lnn	kee	112	KSN	London	Jan-Dec	No	5th Jan
13	unn	mee	113	PN	India	Jan-Dec	No	6th Jan

Data 1 output:

Data 1 Output
Sno	First Name	Last name	Geo Code	Reported Country	Country
1	Vin	wee	101	CN	India
2	sup	qee	102	IN	London
3	nvv	ree	103	KN	UK
4	knn	tee	104	LN	USA
5	enn	yeee	105	AN	Sweeden
6	fnn	uee	106	QN	Poland
7	gnn	iee	107	IN	UK
8	hnn	oee	108	MN	USA
9	amm	pee	109	GN	Sweeden
10	snn	see	110	EN	Poland
11	knn	aee	111	QN	India
12	lnn	kee	112	KSN	London
13	unn	mee	113	PN	India

Data 2 Output:

Data 2 Output
Sno	Collection Period	Current Status	Date Received
1	Jun -Oct	Yes	1st Oct
2	Jun -Oct	No	1st Oct
3	Jun -Oct	Yes	1st Oct
4	Jun -Oct	Yes	1st Oct
5	Jun -Oct	Yes	1st Oct
6	Jun -Oct	Yes	1st Oct
7	Jun -Oct	Yes	1st Oct
8	Jan-Dec	Yes	1st Jan
9	Jan-Dec	Yes	2nd Jan
10	Jan-Dec	Yes	3rd Jan
11	Jan-Dec	Yes	4th Jan
12	Jan-Dec	No	5th Jan
13	Jan-Dec	No	6th Jan

Data 3 Output:

Data 3 Output
Geo Code	Reported Country	Country	Collection Period	Current Status	Date Received
101	CN	India	Jun -Oct	Yes	1st Oct
102	IN	London	Jun -Oct	No	1st Oct
103	KN	UK	Jun -Oct	Yes	1st Oct
104	LN	USA	Jun -Oct	Yes	1st Oct
105	AN	Sweeden	Jun -Oct	Yes	1st Oct
106	QN	Poland	Jun -Oct	Yes	1st Oct
107	IN	UK	Jun -Oct	Yes	1st Oct
108	MN	USA	Jan-Dec	Yes	1st Jan
109	GN	Sweeden	Jan-Dec	Yes	2nd Jan
110	EN	Poland	Jan-Dec	Yes	3rd Jan
111	QN	India	Jan-Dec	Yes	4th Jan
112	KSN	London	Jan-Dec	No	5th Jan
113	PN	India	Jan-Dec	No	6th Jan

Qiu

@vinayvnn
Thank you for the data input.
When you say "if we give the file name say (Data 1 Output) ", I assume there should be a Data File Schema Definition Input.
I made some data as attached,
Then we can filter which output we need, and output the data as the selected output data schema.

0822-vinayvnn.yxmd

vinayvnn

@Qiu Thanks very much for your help, output is as expected

Qiu

@vinayvnn
Happy to be helpful.