Alteryx Designer Desktop Discussions

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

Appending Data - Files from different folders

Punit_Kapadia
7 - Meteor

I have below scenario

 

Folder 1 - Summary Data with Headers (Multiple files based on criteria "Payment Card")

 

AmountCurrencyPayment Card
5000USD10001

 

 

Folder 2 - Transaction Data with Headers (Multiple files based on criteria "Payment Card")  

 

StoreTypeAmountCurrencyPayment Card
ZaraFootwear1000USD1001
H&MWinterwear2000USD1001
AjioPerfumes2000USD1001

 

 

Objective: 

 

Need to combine files in folder 1 and folder 2 with below output

 

Amount CurrencyPayment Card  
5000USD1001  
StoreTypeAmountCurrencyPayment Card
ZaraFootwear1000USD1001
H&MWinterwear2000USD1001
AjioPerfumes2000USD1001

 

Output file has to be seperate for each Payment Card file.  

 

 

2 REPLIES 2
Raj
15 - Aurora

@Punit_Kapadia 
the issue here is you cannot have the different headers one after the other in same column
of you join the data it makes more sense to me 

or what I suggest it you can use output tool capabilities to write this in this format.

Punit_Kapadia
7 - Meteor

Thanks Raj!

Labels