Loading multiple XMLs in a loop and Concatenate Tables Challenge

[#1]

Hello All,

I have a list of folders with 10xml files of the same sets (same table name and structure) but different data by dates. I used a for loop to load all the files into 10 unique tables in a folder.

The challenge is after the 1st folder load, the 2nd folder generates another set of tables by appending XXX-1, XXX-2 to the tables names. I should only have 10tables at the end. I used Concatenate(XXX) but it creates another set of fields rather than appending to the table.  If remove it, get over 50 synthetic tables.

What am I doing wrong? I attach part of table view screen and my script.

Thanks in advance.

Femi

[rwunderlich]

I think the problem is caused by the QUALIFY. Qualify uses the temp-1 table name to create the fields so the auto concatenation does not work. I think the only workaround is to remove the QUALIFY and rename the fields to have different names using the AS clause.

-Rob

[#3]

Thanks Rob,

That's a lot of work...

I have over 500 XML files to combine.....

There's got to be another way. Thanks all the same.

Femi