topic Re: Syn key in QlikView

Syn key

Mon, 20 Oct 2014 09:31:05 GMT

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

Re: Syn key

Gysbert_Wassenaar — Mon, 20 Oct 2014 09:34:03 GMT

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.

Re: Syn key

ashfaq_haseeb — Mon, 20 Oct 2014 09:34:12 GMT

Hi,

No attachment.

Qlik is case sensitive.

Make sure you have same case(Capital or Small)

Regards

ASHFAQ

Re: Syn key

its_anandrjs — Mon, 20 Oct 2014 09:34:12 GMT

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

Re: Syn key

Mon, 20 Oct 2014 09:34:24 GMT

Meant to attach this

Re: Syn key

Anonymous — Mon, 20 Oct 2014 09:36:45 GMT

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.