Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a script like
Load .....;
SELECT * FROM
( Select * from tableA where condition) T1
Full outer join
(Select * from table B) T2
on ((T1.field1=T2.field1) and (T1.field2=T2.field2));
I now have two separate QVDs
1) One for Select * from tableA and other for SELECT * FROM TableB
How can I perform full outer join when loading from QVDs with a where condition for the join??
Thanks in advance.
Thank you. I have a small question. How can I use an Oracle to_char function in LOAD statement? Could you please help me with that?
Can I not do it in a load statement? I have all my data in a QVD
the to_char is an Oracle function
in the load section you can only use Qlik function and there are are a lot of string function
list is in Qlik online help......
what do you want to do with the to_char function in Qlik?
My field in first table was created as a number and the same filed in another table was of varchar type. So I am finding it difficult to compare them.
maybe with
text
num#
from online help
text(expression )
The text function forces the expression to be treated as text, even if a numeric interpretation is possible.