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.
Can you share the Sample Data / Fields which you have .
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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)
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
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..
