Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mapping Load INLFED tables?

I want to clean up my data model, How can I clean up inlfed tables into one

can someone help

5 Replies
Anonymous
Not applicable
Author

file

Anil_Babu_Samineni

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

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

tamilarasu
Champion
Champion

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.

Anonymous
Not applicable
Author

this worked thank you