Mapping

[dseelam]

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

[Anonymous]

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

Categories-- different fields or one field?

[#3]

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

];

[dseelam]

Hello Praveena,

I attached sample QVW and excel to orginal post

I want to accomplish same things with out sync tables

[Anonymous]

Check it here..

I hope it helps!!

[dseelam]

Hello Praveena,

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

[vishsaggi]

What is your expected output here can you post please ?

[dseelam]

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

[dseelam]

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

[#10]

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).