Syn key

[#1]

Hi All,

I thought similar field names on 2 tables meant that QlikView would automatically concatenate. Can someone help me to understand the attached. I have similar field names, but tables have not been concatenated?

Thanks

H

[Gysbert_Wassenaar · Accepted solution]

The two tables needs to have the exact same number of fields with the exact same case sensitive field names. As soon as these conditions are not met Qlikview will create two tables and use the common fields for a synthetic key. Also the load statement should not be preceded by the noconcatenate keyword.

[ashfaq_haseeb]

Hi,

No attachment.

Qlik is case sensitive.

Make sure you have same case(Capital or Small)

Regards

ASHFAQ

[its_anandrjs]

May be its name are not same check once and your attachment is missing.

[#5]

Meant to attach this

[Anonymous]

Hi Herbert,

Best practice is you to force Concatenate or NoConcatenate.

If you want to concat, then do:

Concatenate (tabletoconcatenate) load ...

If you don't want to concat, then do:

yournewtablename:

noconcatenate load ...

Hope it helps.

Marc.