This content has been marked as final. Show 2 replies
Below is a query where I used Lookup (despite warnings) to find the first value from the field FName.
ApplyMap('Company_OrgnoChange',F_orgno) as F_orgno,
ApplyMap('Company_NameChange',F_orgno,Lookup('FName','FOrg',F_orgno,'tmpLookup')) as F_name
Resident Final1 where isnull (KeepNames) and F_orgno <> '#Missing#';
And yes, it is SLOW... very much so.
How could I rewrite the load statement so it is fast, I guess not using Lookup?