This content has been marked as final. Show 2 replies
I have several Excel files with the exactly same structure. When I try to load them all while some fields are unqualified, it auto-numbers the label. How can I use one label instead of several?
My code is as follows,
QUALIFY *; UNQUALIFY id; MyList: LOAD id, name, company FROM List*.csv; UNQUALIFY *;
When the tables are loaded, I get MyList.name, and MyList.company. But I also got MyList-1.name, and MyList-1.company, etc.
Is there's a way I just get a single table like I didn't specify QUALIFY/UNQUALIFY at all?
Thanks a lot.