Data Load Editor(create Table)

[leon511920]

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.

 

[brunobertels]

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 ...