topic How to LOAD qualified columns? in QlikView

How to LOAD qualified columns?

Mon, 21 Mar 2011 20:33:12 GMT

Hello all,

I am designing an application in QV 9.0 SR5. I have to QUALIFY some columns to get the data into the report. After that, I want to LOAD them from the RESIDENT table, but I always get "Field not found" if I just refer to the original, unqualified column name.

How do I refer to a qualified column name in a subsequent LOAD statement?

Example:

QUALIFY *;

UNQUALIFY ID;

FirstTable:

LOAD ID, A, B, C

FROM test.csv;

SecondTable:

LOAD A

RESIDENT FirstTable;

That's where I get the "Field Not Found", I assume because QV no longer sees a column named, "A" but "FirstTable.A" right? So what's the right syntax there then? I've tried FirstTable.A but it doesn't like that.

Thanks!

How to LOAD qualified columns?

Oleg_Troyansky — Mon, 21 Mar 2011 20:43:43 GMT

In your example, FirstTable.A is supposed to be the right answer - just watch the exact spelling, upper and lower case, etc...

You can also try enclosing the field name in square brackets [ ] - like [FirstTable.A]

How to LOAD qualified columns?

Mon, 21 Mar 2011 20:49:17 GMT

Thanks.

It turned out my problem was assuming I knew the table name (in my much more complicated code) but being wrong.I do have spaces in my table names, so my correct answer something like, "[Table A.A]".

I am going to post a new, separate question on why I was wrong but thanks for that answer, Oleg!