Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
raoh
Contributor
Contributor

how to update my table when the data is no longer present

Hello community,
I'm stuck on a data update problem when it's no longer present in my reference file

 

The table which contains my referential :

  • table name : referential with some data
    id | code | domain | active | period |
    1 | 46L | AAAA | true | 04-2020 |
    2 | 46L | BBBB | true | 04-2020 |
    3 | 12M | AAAA | true | 04-2020 ]

at the beginning of every month I am provided with a new referential file (csv format) : name+period.csv => referential_05_2020.csv:
id | code | domain |
1 | 46L | AAAA |
2 | 46L | CCCC |
3 | 12M | AAAA |
3 | 12M | BBBB |

 

I have to update my referential table with these data.

as you can see in my file the data including code '46-L' and domain 'BBBB' is no longer present. Instead of deleting the record i want to update column "active" with false value and update period and insert new record

 

 

Here's what I'm looking for :

exepected output :

id | code | domain | active | period |
----|-------|----------|--------|-----------|
1  | 46L  | AAAA  | true  | 04-2020 |
2  | 46L   | BBBB | false | 05-2020 |
3  | 12M  | AAAA | true  | 04-2020 ]
4  | 46L  | CCCC | true  | 05-2020 |
5  | 12M | BBBB | true   | 04-2020 ]

 

 

 

i've tried :

referential_table ------(MAIN) ----------------- [ tMap ] ------------(output) ---------- referential_table (insert or update)

                                                                        |

                                                                  (Lookup)

                                                                         |

                                                               myCsvFile.csv

Join in my tMap :

         referential_table.code = myCsvFile.code

         referential_table.domain = myCsvFile.domain

match model : Unique Match

Join Model : left outer join

 

all I get as a result is :

id | code | domain | active | period |
1 | 46L | AAAA | true | 04-2020 |
2 | 46L | BBBB | true | 04-2020 |

 

 I'm not getting the new line from the csv file.

 

help, please.

Labels (2)
0 Replies