heirarchy

[kamielrajaram]

Good day,

I have a list of history files which I loop through to create a heirarchy on the users. This works fine, but when I left join to another list of history files it creates a massive synthetic key and numerous tables. Basically I would like to know if ther is a special way of joining tables in a for each loop.

thank you in advance

Kamiel

[#2]

Hi,

Use Qualify'*' for all fields except joining key

Use Unqualiy 'Key_*' for joining key at the begning of loop

Thanks

Vivek