Logical problem with QUALIFY

[datanibbler]

Hi,

I have a very strange thing here:

There is one table that I load by concatenating two LOADs from Excel_files where the table is the same, only the sheet is different. In the second LOAD, I don't specify a table_name - normal, no?

<=> Strangely, when I qualify all the fields (to prohibit any linking between the tables, I want to do that at the very end of all the concatenating and joining I need to do), then the two LOADs are not concatenated, but instead, the fields from the second LOAD appear in the same table, to the right of those from the first - as if they had been joined rather than concatenated - and qualified with the name of the sheet, not the name I have given to the table.

When I just don't qualify that table, all is fine, they are concatenated all right.

Can anyone think of a reason why that can happen?

Thanks a lot!

Best regards,

DataNibbler

[luciancotea]

I tried to replicate your issue with no success. Everything looks fine. It will qualify with the name of the sheet if you don't provide an explicit table name.

Maybe you can provide an example to illustrate your issue.

Lucian

[datanibbler]

Thanks!

So it isn't really possible to concatenate something (a second LOAD) to a table when that is qualified? (because in that case, of course you won't specify a table_name for the second LOAD - or can you?)

[luciancotea · Accepted solution]

Oh, I see now. you used forced concatenation, that is why it joined the initial table.

No, you can't. You have to use manual qualifying. (LOAD field1 AS table1.field1,.,..)

[datanibbler]

Okay.

Thanks!

Then I'll find another way to solve this.

Best regards,

DataNibbler