topic Re. :Using NOCONCATENATE in QlikView

Using NOCONCATENATE

Wed, 06 Apr 2011 16:41:03 GMT

Hi,

I'm reading some tables from a SQL Server db and I want to avoid the linking by name between fields with the same name. I have tried to use the NOCONCATENATE for the Load/Select statement before the storing in the QVDs but I can see some synthetic keys and I want to avoid to proliferate them.

Any suggests to me, please? Many thanks

Re. :Using NOCONCATENATE

vincent_ardiet — Wed, 06 Apr 2011 17:01:21 GMT

Hi,

Try QUALIFY * before your load instruction. Columns will not have the same name and will not be joined.

Regards,

Vincent

Re. :Using NOCONCATENATE

Wed, 06 Apr 2011 17:40:03 GMT

Hi thanks,

but with this statement I rename all fields. I want to allow to join by name for fields with the corrisponding one into a dimension table and to avoid undesirable links. So I have used alias for some fields. However, I haven't reduced the synthetic keys that make unreadable the internal data structure and make hard to solve possible circular references.

Re. :Using NOCONCATENATE

Wed, 06 Apr 2011 17:53:08 GMT

Hi,

write this qualify and unqualify statements before your load

qualify *;
unqualify '*_Key';

Name the Keys you want to connect the tables with "_Key" and by this only those keys will be connected

Regards

sravan

Re. :Using NOCONCATENATE

Wed, 06 Apr 2011 18:30:16 GMT

Or renaming the attribute field to don't to link as I already made. It is the same. But the problem is also to avoid to do to create synthetic keys and tables not wanted.