Full outer join with QVDs on some condition

[reshmakala]

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.

[reshmakala]

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?

[reshmakala]

Can I not do it in a load statement? I have all my data in a QVD

[maxgro]

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?

[reshmakala]

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.

[maxgro]

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.