topic Re: Concatenating Tables in QlikView

Concatenating Tables

Mon, 22 Oct 2012 15:32:30 GMT

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.

Re: Concatenating Tables

fdelacal — Mon, 22 Oct 2012 15:38:42 GMT

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)

Re: Concatenating Tables

Mon, 22 Oct 2012 16:15:19 GMT

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

Re: Concatenating Tables

rwunderlich — Mon, 22 Oct 2012 16:16:37 GMT

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

Re: Concatenating Tables

jeffmartins — Mon, 22 Oct 2012 17:57:51 GMT

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