Related to Qualify and Unqualify and OR with where

[#1]

hello Guys,

I have been trying qualify and unqualify and hope u can help me solve the following 2 problems

Problem 1:

I have the following code for ex:

[Code]

Qualify *;

unqualify '%*';

Table1:

Load Key1 as %Key1,

Field1

..........

.........

FROM ..\SAP_Table_1.QVD(qvd);

Table 2:

Load Key2 as %Key2,

Key1 as %Key1,

Field2,

.........

......

FROM ..\SAP_Table_2.QVD(qvd)

concatenate Load

%Key1,

Field1

Resident Table1;

[/ Code]

Now as I wrote qualify * field1 is Table1.Field1 and it cannot be concanated to Table2. How can I avoid this. I can remove the qualify and unqualify and do it. But I did not use until now qualify and wanted to know if it can be used everywhere without problem.

Problem 2

How can i use this code with where and OR

Table1:
Load Key1 as %Key1,
Field1
..........
.........
FROM ..\SAP_Table_1.QVD(qvd)
where Field1 ='X' or 'Y' or 'Z';

The above code does not work. it takes only X. How can I write the code in another way.

Thanks

[#2 · Accepted solution]

Hi,

use match function in where clause

where match(Field1,'X','Y','Z')>0;

Alex

[spsrk_84]

Hi,

Try like this

Field1='X' or Field1='Y' or Field1='Z'

[#4]

what about Qualify problem?? Anyone has any Idea?

Thanks in advance

[#5]

Hello,

generally you can avoid concatenation by using the prefix 'noconcatenate'.

Table 1:
LOAD
...
FROM ... ;

Table 2:
noconcatenate LOAD
...
FROM ...;

hth,
Thilo