Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

datanibbler
Esteemed Contributor

Logical problem with QUALIFY

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

Tags (1)
1 Solution

Accepted Solutions
luciancotea
Valued Contributor

Re: Logical problem with QUALIFY

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,.,..)

View solution in original post

4 Replies
luciancotea
Valued Contributor

Re: Logical problem with QUALIFY

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
Esteemed Contributor

Re: Logical problem with QUALIFY

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
Valued Contributor

Re: Logical problem with QUALIFY

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,.,..)

View solution in original post

datanibbler
Esteemed Contributor

Re: Logical problem with QUALIFY

Okay.

Thanks!

Then I'll find another way to solve this.

Best regards,

DataNibbler