Unable to read multiple XML files by using dynamic input

sumeet_rk

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 ?

Workflow

Error Message

Dynamic Processing

Accepted answers

caltang

@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.

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

All comments

BS_THE_ANALYST

@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,

sumeet_rk

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

caltang

@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.

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703