Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to clean up my data model, How can I clean up inlfed tables into one
can someone help
file
Try to remove Synthetic Keys which means using
https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/
What is synthetic keys? How it can be avoided?
I tried emulating this synthetic key. but no its not working for me.
Can you show me how to do one . and i will do the rest
Hi Mike,
Looks like you are new to Qlikview . Please find the attached file. I have used Apply Map and preceding load concept to map the data. You can also use Left join to join the data. But the goal is to remove the synthetic keys. Search in google and learn about these topics (Synthetic keys, Apply map, Left join, Preceding load). Good luck.
this worked thank you