Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (2)
4 Replies
fdelacal
Valued Contributor

Re: Concatenating Tables

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

Re: Concatenating Tables

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

Re: Concatenating Tables

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
Contributor II

Re: Concatenating Tables

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

Community Browser