Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hey @AshutoshBhumkar Thankyou so much for quick reply. It gives correct Results.