Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi Masthan
In theory you should be able to delete the records. That is what the Inner Join in Step 5 in my original post is for.
For example, say we have the following table in the QVD:
ID | Product |
1 | Apple |
2 | Banana |
3 | Pear |
4 | Grape |
5 | Lemon |
And then the source changes to the following:
ID | Product |
1 | Apple |
2 | Banana |
3 | Pear |
5 | Lemon |
6 | Peach |
When we go through the steps, then the new row loaded will be:
ID | Product |
6 | Peach |
When you concatenate the QVD it will become:
ID | Product |
1 | Apple |
2 | Banana |
3 | Pear |
4 | Grape |
5 | Lemon |
6 | Peach |
When you Inner Join the IDs in the source file again, then ID 4 will be removed (since it is no longer in the source table's IDs) leaving you with:
ID | Product |
1 | Apple |
2 | Banana |
3 | Pear |
5 | Lemon |
6 | Peach |
This is then stored into the QVD again.
Hope this makes sense.
Regards,
Mauritz