Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

combining one table from few, with one common field, filling in data from different sources

hello guys,

trying allways to search berofe asking and ussualy it works not now...

i am working of messy data set where regarding on origin of the data (ID field) i need to fill in one column (code) from many tables.

Here is the situation:

   

table1
codedescriptionidamount
-112
-212
-312
-code [a4]434
-code [a5]523
-code [a6]613
--735
--846
--946

p.s. using subfield (description) i know how to extract code.

   

table 2
idcode
7a7
8a8
9a9

   

table 3
idcode
1a1
2a2
3a3

I want to create new table, or fill in TABLE 1 to have this data:

   

NEW table
code_combinedamount
a112
a212
a312
a434
a523
a613
a735
a846
a946

Tried to use left join, but data from Table 2 and Table 3 starts to "fight", first loaded - wins. Other IDs remains empty.

Any ideas?

1 Reply
Not applicable

Re: combining one table from few, with one common field, filling in data from different sources

Any ideas?