Create Flag

[suzel404]

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,

!

[Peter_Cammaert · Accepted solution]

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

[suzel404]

Thank you Peter.