Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx output into different output files using macro

vinayvnn
7 - Meteor

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.

 

 

7 REPLIES 7
Qiu
21 - Polaris
21 - Polaris

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

vinayvnn
7 - Meteor

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
21 - Polaris
21 - Polaris

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

vinayvnn
7 - Meteor

@Qiu Apologies for the inconvenience. 

Please see the output below:

 

Master Data Output:

Master Data
SnoFirst NameLast nameGeo CodeReported CountryCountryCollection PeriodCurrent StatusDate Received
1Vinwee101CNIndiaJun -OctYes1st Oct
2supqee102INLondonJun -OctNo1st Oct
3nvvree103KNUKJun -OctYes1st Oct
4knntee104LNUSAJun -OctYes1st Oct
5ennyeee105ANSweeden

J

un -Oct

Yes1st Oct
6fnnuee106QNPolandJun -OctYes1st Oct
7gnniee107INUKJun -OctYes1st Oct
8hnnoee108MNUSAJan-DecYes1st Jan
9ammpee109GNSweedenJan-DecYes2nd Jan
10snnsee110ENPolandJan-DecYes3rd Jan
11knnaee111QNIndiaJan-DecYes4th Jan
12lnnkee112KSNLondonJan-DecNo5th Jan
13unnmee113PNIndiaJan-DecNo6th Jan

 

Data 1 output:

Data 1 Output
SnoFirst NameLast nameGeo CodeReported CountryCountry
1Vinwee101CNIndia
2supqee102INLondon
3nvvree103KNUK
4knntee104LNUSA
5ennyeee105ANSweeden
6fnnuee106QNPoland
7gnniee107INUK
8hnnoee108MNUSA
9ammpee109GNSweeden
10snnsee110ENPoland
11knnaee111QNIndia
12lnnkee112KSNLondon
13unnmee113PN

India

 

Data 2 Output:

Data 2 Output
SnoCollection PeriodCurrent StatusDate Received
1Jun -OctYes1st Oct
2Jun -OctNo1st Oct
3Jun -OctYes1st Oct
4Jun -OctYes1st Oct
5Jun -OctYes1st Oct
6Jun -OctYes1st Oct
7Jun -OctYes1st Oct
8Jan-DecYes1st Jan
9Jan-DecYes2nd Jan
10Jan-DecYes3rd Jan
11Jan-DecYes4th Jan
12Jan-DecNo5th Jan
13Jan-DecNo6th Jan

 

Data 3 Output:

Data 3 Output
Geo CodeReported CountryCountryCollection PeriodCurrent StatusDate Received
101CNIndiaJun -OctYes1st Oct
102INLondonJun -OctNo1st Oct
103KNUKJun -OctYes1st Oct
104LNUSAJun -OctYes1st Oct
105ANSweedenJun -OctYes1st Oct
106QNPolandJun -OctYes1st Oct
107INUKJun -OctYes1st Oct
108MNUSAJan-DecYes1st Jan
109GNSweedenJan-DecYes2nd Jan
110ENPolandJan-DecYes3rd Jan
111QNIndiaJan-DecYes4th Jan
112KSNLondonJan-DecNo5th Jan
113PNIndiaJan-DecNo6th Jan
Qiu
21 - Polaris
21 - Polaris

@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.png

vinayvnn
7 - Meteor

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

Qiu
21 - Polaris
21 - Polaris

@vinayvnn 
Happy to be helpful.

Labels
Top Solution Authors