concatenate

[raadwiptec]

I have multiple sources with some of them the same field names like year, month,material etc. when i use concate nate ..still i get the synthetic key issues.  its is not advisable to use alias for my script.

any other ideas?

s

[Gysbert_Wassenaar]

Yeah, well. I can't mind read qlikview documents half a world away. So good luck.

[Anonymous]

try ....

after Qualifying the tables,

by Qualifying you can avoid the synthetic keys,in your situation.

[raadwiptec]

Qualfying gives an entirely new name and there would be not any link