topic Re: Loading multiple XMLs in a loop and Concatenate Tables Challenge in QlikView

Loading multiple XMLs in a loop and Concatenate Tables Challenge

Thu, 27 Mar 2014 23:53:11 GMT

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

Re: Loading multiple XMLs in a loop and Concatenate Tables Challenge

rwunderlich — Fri, 28 Mar 2014 04:56:23 GMT

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

Re: Loading multiple XMLs in a loop and Concatenate Tables Challenge

Fri, 28 Mar 2014 10:23:31 GMT

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