Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Unable to read multiple XML files by using dynamic input

sumeet_rk
7 - Meteor
Error :- Dynamic Input (17) The file "deeaa84c940594d_Payload.xml" has a different schema than the 1st file in the set.
 
I tried using wildcard in the input tool , But that doesn't work
 

I want to merge the two xml files like union

 

Does anyone know any other different approach ?

3 REPLIES 3
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@sumeet_rk  you've got two options. First, drag the two files on separately. This way, when you add a union tool afterwards, it'll account for the differences in the schemas. The second, is to use a batch macro. This will iterate through and union your files.

 

All the best,

BS

All the best,
BS

LinkedIN

Bulien
sumeet_rk
7 - Meteor

Hi @13 - Pulsar , Can you please provide me with an example please ? Still I am getting the same error.

caltang
17 - Castor
17 - Castor

@sumeet_rk his username isn't 13 - Pulsar, that's his rank. His username is @BS_THE_ANALYST 

 

For the first option, just drag two Input tools, and find your files. Then, use a Union tool to combine them together.

image.png

 

For the Batch Macro: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels