Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
When I created the table, I ended up with a table structure like this.
I would like to do data1-data2, but I can't do .
Does anyone know the reason for this hyphenated structure?
(To make the table, I use left join.maybe the left join is not good....)
Thannk you so much.
Hi
you get this kind of table because Qlik does'nt know wich row to join from table 2 to table 1.
then Qlik create a cartesian product with the 2 tables resulting in this structure above ( your picture )
Try somthing like this
data1:
Load
rownow() as RowID,
data1
from ...
data2 :
leftjoin(data1)
load
rownow() as RowID,
data1
from ...