Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Syn key

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

1 Solution

Accepted Solutions

Re: Syn key

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.


talk is cheap, supply exceeds demand
5 Replies

Re: Syn key

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.


talk is cheap, supply exceeds demand

Re: Syn key

Hi,

No attachment.

Qlik is case sensitive.

Make sure you have same case(Capital or Small)

Regards

ASHFAQ

Re: Syn key

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

Not applicable

Re: Syn key

Meant to attach this

marcarreras
Valued Contributor

Re: Syn key

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.

Community Browser