Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
use match function in where clause
where match(Field1,'X','Y','Z')>0;
Alex
Hi,
use match function in where clause
where match(Field1,'X','Y','Z')>0;
Alex
Hi,
Try like this
Field1='X' or Field1='Y' or Field1='Z'
what about Qualify problem?? Anyone has any Idea?
Thanks in advance
Hello,
generally you can avoid concatenation by using the prefix 'noconcatenate'.
Table 1:
LOAD
...
FROM ... ;
Table 2:
noconcatenate LOAD
...
FROM ...;
hth,
Thilo