topic Re: Mapping Load INLFED tables? in QlikView

Mapping Load INLFED tables?

Anonymous — Mon, 22 Jan 2018 00:02:27 GMT

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

can someone help

Re: Mapping Load INLFED tables?

Anonymous — Mon, 22 Jan 2018 00:03:27 GMT

file

Re: Mapping Load INLFED tables?

Anil_Babu_Samineni — Mon, 22 Jan 2018 00:28:59 GMT

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?

Re: Mapping Load INLFED tables?

Anonymous — Mon, 22 Jan 2018 02:09:01 GMT

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

Re: Mapping Load INLFED tables?

tamilarasu — Mon, 22 Jan 2018 03:12:04 GMT

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.

Re: Mapping Load INLFED tables?

Anonymous — Tue, 23 Jan 2018 03:15:27 GMT

this worked thank you