Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I identify with a flag in script all ID without TYPE_ID = 4 and ID WITH TYPE _ID = 4
Thanks for your help.
Regards,
!
Not too difficult, I think. Like this (there are multiple possible solutions)?
MapIDHasType4:
MAPPING
LOAD ID, 1 AS Flag
FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$)
WHERE (TYPE_ID = 4);
IDsNTypes:
LOAD ID, TYPE_ID, ApplyMap('MapIDHasType4', ID, 0) AS FlagHasType4
FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$);
Add whatever other calculations you need to the last straight LOAD.
Best,
Peter
Not too difficult, I think. Like this (there are multiple possible solutions)?
MapIDHasType4:
MAPPING
LOAD ID, 1 AS Flag
FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$)
WHERE (TYPE_ID = 4);
IDsNTypes:
LOAD ID, TYPE_ID, ApplyMap('MapIDHasType4', ID, 0) AS FlagHasType4
FROM FLAG_TYPE.xls (biff, embedded labels, table is Sheet1$);
Add whatever other calculations you need to the last straight LOAD.
Best,
Peter
Thank you Peter.