Qualify for Particular tables

[Anonymous]

Hi All,

How to use Qualify for Particular tables in Different Tab's.

Thanks,

Krishna

[HirisH_V7]

We can use  QUALIFY and UNQUALIFY to bring in new tables and you want to link on one Common  field, Others are Not in common means.

QUALIFY *;
UNQUALIFY Date;
UNQUALIFY OrderID;
Orders:    
     LOAD OrderID,
               Date,
               OrderName,
               CustomerName,
     FROM Table.xls;

UNQUALIFY *;

This will result in a table with fields like this:

     OrderID

      Date

     Orders.OrderName

     Orders.CustomerName

Here in the Above table the OrderID and Date Fields are Common and others belonged to Individual Tables.

Post your sample. If Scenario Doesn't look like above.

Hope this helps,

Hirish

[Kushal_Chawda]

Hi,

Qualify statement used to resolve the synthetic keys in tables.

Lets consider the below scenario. You have two table like this

A:

ID,

Date,

Name,

...

FROM table 1

B:

ID,

Date,

Name

FROM table 2

When you load these tables, synthetic key will be generated due to common column ID,Date, Name

But, actual key between two tables is ID only. So there are two ways to resolve synthetic key.

1) Rename the fields which is not required as key

A:

ID,

Date as DateA,

Name as Name A,

...

FROM table 1

B:

ID,

Date as DateB,

Name as NameB

...

FROM table 2;

2) Use Qualify statement like below

Qualify *;

Unqualify ID;

A:

ID,

Date as DateA,

Name as Name A,

...

FROM table 1;

B:

ID,

Date as DateB,

Name as NameB

...

FROM table 2;

Unqualify *;

So here we are unqualifying the ID , rest fields in the table will be qualify which will be renamed like below

tablename.fieldname

So, Table A Fields will be renamed as

A.Date

A.Name

and Table B field will be renamed as

B.Date

B.Name

So finally in both the case table will be linked on ID only.

[mithilesh17]

Hi,

check this useful thread

Do you Qualify?- How to use QUALIFY statement

Regards,