Load all rows in script from a file

[razvan_brais]

Hy guys. I would like to load all rows from a file even if there is no associations between table.

I`m having three tables.

Table1 with ID , Date , Value

Table2 with ID , Level1 , Level2,

Table3 with Level1 , Level2,Budget.

When I`m using the normal load it will only load all fields that have a match between tables.

Such as:

ID	Date	Value
1	06/01/2016	100
2	07/01/2016	50
3	08/01/2016	150

ID	LEVEL1	LEVEL2
1	Electronics	Laptops
2	Electronics	SmartWatches
3	Electronics	SmartPhones
4	Electronics	Gaming

Level1	Level2	Budget
Electronics	Laptops	700
Electronics	SmartWatches	300
Electronics	SmartPhones	400
Electronics	Gaming	200

What I want to do is to show all data in a pivot table even if there is no association between Table1 and Table 2. The result I would like to look something like this :

ID	LEVEl1	LEVEL2	Value	Budget
1	Electronics	Laptops	100	700
2	Electronics	SmartWatches	50	300
3	Electronics	SmartPhones	150	400
4	Electronics	Gaming	0	200

Please help me , because I can`t find a way to do this.

[Gysbert_Wassenaar]

MyTable:

LOAD ID, Date, Value FROM Table1;

JOIN (MyTable)

LOAD ID, LEVEL1, LEVEL2 FROM Table2;

JOIN (MyTable)

LOAD Level1 as LEVEL1, Level2 as LEVEL2, Budget FROM Table3;

[varshavig12]

Rename the columns

[Anil_Babu_Samineni]

Try

Join(Table Name)

Then use Qualify & Un Qualify for that to get updated Values

Level1 as LEVEL1 , Level2 as LEVEL2 for 3rd Table while resident

[razvan_brais]

I don`t want to rename the columns because I will need the same column name in expressions.

Gysbert . The problem is that my First table will be stored in a qvd file , and I don`t want to save all of the info from those three tables.

[razvan_brais]

Can you pls attach the qvw file?

[Gysbert_Wassenaar]

If you don't want to rename fields then you will end up with a monster that will eat all your ram and cpu cycles and molest your kittens. Don't try to make Qlikview do things it shouldn't do.

If you don't want to store the resulting joined table in a qvd then simply don't store it in a qvd. Nobody's forcing you to do so.

[Anil_Babu_Samineni]

Try This, For ref

[razvan_brais]

You are saying that if I have the same column name it will put in my table all of the data?

[razvan_brais]

Anil , it doesn`t work. I`m trying to show all data in a pivot table. But I have no success in doing that.