Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
16 - Nebula

@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
Top Solution Authors