topic Re: Reloading Columns from Table with Qualifier in QlikView

Reloading Columns from Table with Qualifier

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to reload table which has qualifier using resident but getting error while reloading, I am using below script , please suggest

Qualifier : T

Existing table name: Table 1

Columns:

COl1 as " Emp Name"

COL2 as "Department"

LOAD

T. [Emp Name],

T.[Department]

Resident Table1;

ramasaisaksoft — Tue, 30 Aug 2016 06:43:04 GMT

Hi Vibhu,

There is no Qualifier key word in qv.

Below example will help you to achieve ur requirement.

qualify *;

LOAD name,

col1,

col2

FROM

[..\Rama Sai\Test.xlsx]

(ooxml, embedded labels, table is Sheet1);

UNQUALIFY *;

sai:

NoConcatenate

LOAD T.name,

T.col1,

T.col2

Resident T;

drop Table T;

please let me know if u face any issues.

Anonymous — Tue, 30 Aug 2016 06:51:59 GMT

Though Rama have already explained, but you can check this as well?