Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
LLing
Contributor III
Contributor III

Add rows for each date using values from another table

Hello,

I have 2 tables as shown.

Screenshot (347).png

 

For each date, I want to have a row containing each unique value of table2 field1. In table1, on 1/7/2021, field1 has value A, B and C are missing. On 2/7/2021, field1 has values A and B, C is missing. The final table I am looking for is as below  where the highlighted rows are the missing rows I want to add in.

Screenshot (350).png

 

Any suggestions on how I can achieve this in my load script? Thanks.

Labels (3)
0 Replies