Discussion Board for collaboration on QlikView Scripting.
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.
YOU ARE WRITING CONCATENATE (YOURFIRSTTABLE)
IT CAN BE POSSIBLE THAT YOU CAN CONCATENATE WITH ANOTHER TABLE, YOU MUST PUT THE NAME
IN TH EXAMPLE
I know the formula for Concatenate. I am having problems after concatenating the 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
Try to use noconcatenate prefix when you load the second table. Maybe the second table wasn't created due to automatic concatenation.