Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using NOCONCATENATE

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

4 Replies
vincent_ardiet
Specialist
Specialist

Hi,

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

Regards,

Vincent

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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.