Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following code which works exactly how I want it to, but when I reload the code again, I get the information duplicated. I think I need to put a "WHERE NOT EXISTS" statement in but I can't figure out how to do this.
Here's the code:
TrackerTemp:
LOAD *
FROM
Concatenate(TrackerTemp)
/*Not Made - Due*/
LOAD *,
'ukOpenOrdersNot_MadeDue' & num(today()) & 'UD' as [ID],
'uk' as Database,
'UD' as Entity,
today() as Date,
'OpenOrders' as AppName,
'Not Made' as FieldName,
'Due' as FieldType,
sum(if([Status]='Due' and [Category]='Not Made',[Value To Make],'Not Found')) as [Value]
Resident CustTable;
So I load TrackerTemp, then I get the new information from CustTable and it concatenates the two, but if I get run it again I get duplicate entries.
Thanks
Chris
You just need to add distinct after your load statement, I would really recommend you to go through the below link so that you can understand the whole functionality
http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/
Why don't you use Distinct?
Could you give me an example please? I've never used DISTINCT before, not in QV anyway
Cheers
Chris
You just need to add distinct after your load statement, I would really recommend you to go through the below link so that you can understand the whole functionality
http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/
Brilliant. Great read. I always thought the LOAD DISTINCT only apply to the information it was loading - not to the resulting table. This worked perfectly.
Cheers
Chris