topic Re: Mapping in QlikView

Mapping

dseelam — Fri, 23 Sep 2016 19:11:38 GMT

Hello All

I have 2 fields ID & categories in data model from oracle, Now I have an flat file with diff ID and categories missing from oracle

now I want to include flat file in to data model and map categories from both sources in to Make or Buy

how is it possible?

Message was edited by: Dinesh Reddy Seelam

Re: Mapping

Anonymous — Fri, 23 Sep 2016 19:26:13 GMT

Can you post sample? I am not sure exactly what you want!

Categories-- different fields or one field?

Re: Mapping

Fri, 23 Sep 2016 20:09:42 GMT

If I'm understanding you correctly

For the first part (flat file with missing categories) all you need to do is load the flat file using the same field names as your oracle table. Qlikview will concatenate them together by default.

For the mapping them to Make or Buy you will just need a 2 column file that has the same column name for ID as the other two sources and a new column with Make or Buy

If I were to solve with Just inline tables it would Look like this

//Oracle Data
LOAD * INLINE [
Category, ID
A, 1

B, 2

C, 3

]

//Missing Data
LOAD * INLINE [
Category, ID
E, 4

F, 5

];

//Mapping

LOAD * INLINE [
ID, Work_Type
1, Make

2, Buy

3, Make

4, Buy

5, Buy

];

Re: Mapping

dseelam — Fri, 23 Sep 2016 20:12:51 GMT

Hello Praveena,

I attached sample QVW and excel to orginal post

I want to accomplish same things with out sync tables

Re: Mapping

Anonymous — Fri, 23 Sep 2016 20:35:16 GMT

Check it here..

I hope it helps!!

Re: Mapping

dseelam — Fri, 23 Sep 2016 20:43:11 GMT

Hello Praveena,

you are not using flat file attached so missing flat file tab in the script with all the results in front end

Re: Mapping

vishsaggi — Fri, 23 Sep 2016 21:29:51 GMT

What is your expected output here can you post please ?

Re: Mapping

dseelam — Mon, 26 Sep 2016 12:31:45 GMT

Hi vishnu,

I attached a QVW & flat file to my original post can you check I want the same out put as it is now in QVW with out sync tables

Re: Mapping

dseelam — Mon, 26 Sep 2016 12:36:40 GMT

Hello Matthew,

I did the same thing instead of add did concatenate the flat file with original but still not able to get rid of sync tables!

Thanks

Re: Mapping

Mon, 26 Sep 2016 14:01:28 GMT

Take category out of your finished-1 table. Having 2 columns that are in both tables is what's causing your $Syn 1 Table. Technically if id and category are 1 to 1 you don't need both in finished-1.

If id and category are not 1 to 1 then create a third column that is ID-CATEOGRY and have that column in finished 1 and not id or category. There is no Synthetic Key in my tables.

I did upload a sample with my code in it (sorry I didn't reuse your data. I can if you need me to).

Re: Mapping

krishnacbe — Mon, 26 Sep 2016 14:43:33 GMT

Hi Dinesh,

Please find the attached solution.

After concatenate/Join/Add statement, you have used apply map with * statement, that caused the Synthetic Keys.

Dropping the first table will solve the issue. But verify the data.

Re: Mapping

vishsaggi — Mon, 26 Sep 2016 14:44:29 GMT

Try this to concatenate !

Leave the Mapping table and Finished table as is and do below and refresh and see?

In the Edit Script Flatfile Tab:->

Concatenate

LOAD id,