Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the two following tables :
OldTable :
ID | Old Standard |
---|---|
1 | ST1 |
2 | ST2 |
3 | ST2 |
4 | ST2 |
NewTable
ID | New Standard |
---|---|
1 | ST1 |
2 | ST2 |
3 | ST2 |
4 | ST1 |
And I would like to have a KPI to count the number of Standard difference between the two tables, that is to say : count(DISTINCT MSN where New Standard is different from Old Standard) but I don't manage to do that.
I don't want to join tables because I have a lot of others columns so it will be very heavy and I need each table to be independant.
If you have any idea, don't hesitate
best regards
Count(aggr(if(Old Standard = New Standard,1)ID)
or
sum(aggr(if(Old Standard = New Standard,0,1)ID)
Hi,
You can use exists function to know if the record is loaded earlier or not.
Try this,
Table1:
Load ID&OldStandard as Key
From xyz;
Table2:
Load *,if(Exists(Key,ID&NewStandard),'No Different','Different') as Status
From pqr;
Regards,
Kaushik Solanki
thank you very much, this could work ! But I would like to avoid creating a new table because my data is very heavy and it already takes a lot of time to load
Caroline Huet schrieb:
... I need each table to be independant.
Hi Caroline,
...but you know, that Qlik will create an outer join automatically if two tables use same fields? That means your both tables are linked because of the field "ID"...
Yes, I use that link to do some calculations but I don't want to join table with an "outer join" in the data load editor
Count(aggr(if(Old Standard = New Standard,1)ID)
or
sum(aggr(if(Old Standard = New Standard,0,1)ID)