Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenating Tables

Hi,

I am trying to concatenate two tables . They have similar column names. Now when I did that , I get values from primary table but not from the table  I am concatenating. Can anyone give me any suggestions.

4 Replies
fdelacal
Specialist
Specialist

YOU ARE WRITING CONCATENATE (YOURFIRSTTABLE)

IT CAN BE POSSIBLE THAT YOU CAN CONCATENATE WITH ANOTHER TABLE, YOU MUST PUT THE NAME

IN TH EXAMPLE

CONCATENATE (VALUE)

Not applicable
Author

I know the formula for Concatenate. I am having problems after concatenating the tables.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It may be that you are looking at the values in a tablebox. QV will list only one row for each combination of values, so it may appear you don't have the additional rows.

Check the table rowcount to confirm whether the secind table is loaded. You can also add a primary key and use that in the tablebox to create unique rows. Add this to your script to generate the PK.

rowno() as RecId

-Rob

jeffmartins
Partner - Creator II
Partner - Creator II

Hi amitvernekar,

Try to use noconcatenate prefix when you load the second table. Maybe the second table wasn't created due to automatic concatenation.

Regards