
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Union and join tables
Hello Guys,
I have 3 tables, A, B and C. I need to make in Load Script an union between B and C and then a join with A. how can I do?
I tried in this way (it doesn't work):
Load * from A;
inner join
temp:
Load * from B;
Concatenate(temp)
Load * from C;
Tables B and C have the same columns.
Thank you so much
- Tags:
- qlikview_deployment
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
temp:
Load * from B;
Concatenate(temp)
Load * from C;
join(temp)
Load * from A;
you can change your join type accordingly


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load * from A;
inner join
temp:
Load * from B;
Concatenate(temp)
Load * from C
where not exists(key coloumn);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
temp:
Load * from B;
Concatenate(temp)
Load * from C;
join(temp)
Load * from A;
you can change your join type accordingly


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
when you joined A and B , B ceases to exist and it is now part of table A that is why concatenate didn't work
Two thing you can try
1:
temp:
Load * from B;
Concatenate(temp)
Load * from C;
join(temp)
Load * from A;
2:
try using keep and see if it works for you and suitable for your requirement
regards
Pradosh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much
