2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you uninstall it, and then install the latest 2022.1.1.30961 version.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
15 - Aurora

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
15 - Aurora

@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
15 - Aurora

@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