Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Input and Join

meitata
7 - Meteor

I have a file with multiple sheets and this is the header of sheets:

  • A B C D E
  • A B C D F
  • A B C D G
  • A B C D H
  • A B C D I

Is it possible to join the file with header A B C D E F G H I with macro or less tools?

12 REPLIES 12
AmalinaH
Alteryx
Alteryx

** correction **

 

Apologies! I believe I misunderstood your question. For combining different sheets that have different schema, this discussion and solution posted here may have what you are looking for:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Multiple-Sheets-with-Different-F...

meitata
7 - Meteor

is it work if the data have different schema?

AmalinaH
Alteryx
Alteryx

This thread here looks like it has what you are looking for:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Multiple-Sheets-with-Different-F...

 

It would involve using a batch macro.

grazitti_sapna
17 - Castor

Hi @meitata, is this what you are trying to achieve from the input source having multiple schemas?

 

grazitti_sapna_0-1655877692840.png

 

Let me know if that is what you are looking for?

 

Thanks!

 

Sapna Gupta
meitata
7 - Meteor

Yes, that's what I lookin for! Lemme know how to do it? @grazitti_sapna 

grazitti_sapna
17 - Castor

@meitata, I have created a macro for this posting my workflow here.

Please go through it once and let me know if you have any questions.

 

Thanks!

Sapna Gupta
meitata
7 - Meteor

Can you explain me what does File New in folder 2 contains? @grazitti_sapna 

 

grazitti_sapna
17 - Castor

@meitata, it is just a file template that I used in the dynamic input tool for reference. It will be replaced with the filename passed outside the macro.

 

Thanks!

Sapna Gupta
meitata
7 - Meteor

@grazitti_sapna okay, so I'll try it! Thanks a lot for your help!

Labels