Reloading Columns from Table with Qualifier

[#1]

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]

Hi Vibhu,

There is no Qualifier key word in qv.

Below example will help you to achieve ur requirement.

qualify  *;

T:

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]

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

Do you Qualify?- How to use QUALIFY statement