How to use QUALIFY

[#1]

Help in how to use qualify.

[MayilVahanan]

Hi

For whole table:

Qualify *;

Load * from datasourcename;

UnQualify *;

For Field name in table:

Qualify B;

Load A,B from tableName;

Please refer the help for further details

[#3]

I have used the Qualify like below as I don't have chance to use *. it's getting Field names must be Unique

Qualify *;

Load column1,column2,........ from datasourcename;

UnQualify *;

[MayilVahanan]

Hi

In datasourcename, is there any same column name??

[#5]

Yes In one table it is name and in other table it is NAME. that's why it is getting field not found. please help

[tresesco · Accepted solution]

Hi,

it has been a long effort.

Lets try and check step by step:

Step1: Try to load the first table alone with Load * From.... . Is it going smooth? or getting that uniquness error?

if yes. It has nothing to do with qualify. your table is having multiple fields with same name; you have to identify that.

Once step1 is done will come up with step2.

[#7]

Hi

QUALIFY will prefix field's name by table name like Table.Field

Beware of using it when you do some treatments on table.

It is better to use it only on the last table.

Don't forget to unqualify Fields you want to user as a key

Ex : Unqualify %K;

You may use a variable like

SET vUnqualify = Unqualify %K;

and then

$(vUnqualify);

So you have only one line to change

best regards

Chris