Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please post a small qlikview document that demonstrates the problem.
Can you share the Sample Data / Fields which you have .
it would be difficult as.. the existing report lines of code is more than 3000 lines and iam trying to add a new source file which has the similiar fields ..
i tried concatenating ..but iam getting sythetic keys..
Make sure you're concatenating it to the right table. Make a habit of explicitly specifying the table name you want to append the data to: CONCANATE (MyTargetTable)
Hi,
Use qualify and unqualify functions for avoiding synthetic keys.
Thanks,
Hi ,
Please share sample data ,it will useful to understand your problem.
Post your script.
Regards,
If you can't post the script, please post image of table viewer (Ctrl-T)
Marty.
hi gysbert,
In the script there are couple of table which are made as link table.. iam basically trying to concatenate the the new source file with the Link table.. but it is going for loops..