Finding missing data

[RK01923683]

Dear Experts,

I need your help.

We have some devices, those should send data on daily basis. This data we extract using qlik. Sometimes some devices don't send data.Any Suggestions how can i verify which devices are not sending data.

i have list of all the devices in dimension table

Can we do this by joining fact table with dimension table? May be this way we can verify which devices are there is dimension table but not in fact table. If yes how i can do this.

any other way?

Please Help!

Thanks in Advance.

[AshutoshBhumkar · Accepted solution]

Hello,

I have created a sample dataset and output to understand the question. Correct me if I am wrong. 

MasterData:
Load * Inline [
Device
A
B
C
];

Left Join

FactData:
Load * Inline [
Device, Date, Data
A, 19/09/2021, dwfaergetg
B, 20/09/2021, dweucwgi

];
NoConcatenate

MainTable:
Load Device, Date, If(Len(Data)=0,'NO Data', Data) as Data
Resident MasterData;
Drop Table MasterData;

Is this what is expected?

Thanks,

Ashutosh

[RK01923683]

Hey @AshutoshBhumkar  Thankyou so much for quick reply. It gives correct Results.