Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

concatenated tables and then join

Hi ,

I have a wierd scenario that is

Table1:

load A, B, C

from table1;

concatenate(Table1)

load A, B, C

from table2;

concatenate(Table1)

load A, B, C

from table3;

join(table1)

Load A, B, D, E from facttable_*;

after join statement facttable_* , Here * indicates years 2011, 2012, 2013. it will have 3 tables which needs to be concatenated and then join. Problem from me is , the second (2012 ) QVD and third 2013 QVD is not joining properly. Because of that i am not getting the data from the second and 3rd QVD. Need your inputs on how to solve this issue.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Its very big file. I have the solution here but wanted to find out , why above scripting is not working. What i did was push above three concatenates to one QVD and even the fact also the same way and then join them , it is working fine.

View solution in original post

5 Replies
shree909
Partner - Specialist II
Partner - Specialist II

Hi i dont know just give a try.

Concatenate all the 3 tables and take resident  of 3 tables and join with ur fact table;

Thanks

Anonymous
Not applicable
Author

did tried that by taking first three tables as concatenate .. pushed into QVD and used that QVD and joined that to my fact table...Do you think fact table might have an issue.

shree909
Partner - Specialist II
Partner - Specialist II

looks like have an issue with fact table;

if possible could you post a  sample file.

Thanks

Anonymous
Not applicable
Author

Its very big file. I have the solution here but wanted to find out , why above scripting is not working. What i did was push above three concatenates to one QVD and even the fact also the same way and then join them , it is working fine.

maxgro
MVP
MVP

change

join(table1)

Load A, B, D, E from facttable_*;

to

join(Table1)

Load A, B, D, E from facttable_* (qvd);

it should work; if you still have problems you can load the 3 qvd files without join and see the result in table viewer

facttable:

Load A, B, D, E from facttable_* (qvd);