Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

How to concatenate 4 tables

Hi All,

Please look at the file. I want to concatenate into single file

Please help me?

Thanks,

Siva

1 Solution

Accepted Solutions
siva_boggarapu
Creator II
Creator II
Author

Hi

Can you take my scrip. In First table I have 200 Records and 2nd table 200 records. When I use concatenation I am getting 200 records instead 400 records

IF possible can you send me script using my script

thanks

Siva

View solution in original post

3 Replies
rittermd
Master
Master

If two tables have the exact same layout (like a file for each year) then they will automatically concatenate unless you tell it not to.

If they don't have the same layout then you can code Concatenate in your script between the 2 files and they will do that. 

That is the simple answer.

siva_boggarapu
Creator II
Creator II
Author

Hi

Can you take my scrip. In First table I have 200 Records and 2nd table 200 records. When I use concatenation I am getting 200 records instead 400 records

IF possible can you send me script using my script

thanks

Siva

zebhashmi
Specialist
Specialist

Can you share a sample qvf file

I would say User one table name

Like

[IntakePeriod]:

Load from table 1;

Load from Table 2;