Loading IF statement

[#1]

Hi,

I am struggling with the loading script using IF below, appreciate anyone's help :

[TCODE]:
LOAD fileNumber

if(([trackCode]='BOOKED') AND [TransportMode]={'B','V'}) as TB
if(([trackCode]='BOOKCONF) AND [TransportMode]={'P','T'}) as TD
resident [Shipment];

The shipment already has trackCode and TransportMode fields, the problem is the syntax error.

Thank you.

Regards,

AG

[swuehl]

Your if() statements need at least a THEN branch, and check your string value matching, like

if(([trackCode]='BOOKED') AND Match([TransportMode],'B','V'), 'Yipiieh!'  ) as TB

[sunny_talwar]

May be try this:

[TCODE]:
LOAD fileNumber

          If([trackCode]='BOOKED' and WildMatch([TransportMode], 'B','V'), 1, 0) as TB
          If([trackCode]='BOOKCONF' and WildMatch([TransportMode], 'P','T'), 1, 0) as TD
Resident [Shipment];

[Chanty4u]

ur missing single quote

[TCODE]:
LOAD fileNumber

if(([trackCode]='BOOKED') AND [TransportMode]={'B','V'}) as TB
if(([trackCode]='BOOKCONF') AND [TransportMode]={'P','T'}) as TD
resident [Shipment];

[saniyask]

Hi,

Please try this..

Regards,

Saniya

[Chanty4u]

Hi,

It means i think Missing the single Quote

The shipment already has trackCode and TransportMode fields, the problem is the syntax error.

[satishkurra]

Extending to sunny syntax, we can use below in Red to give a meaningful name using Dual

[TCODE]:
LOAD fileNumber

          If([trackCode]='BOOKED' and WildMatch([TransportMode], 'B','V'), Dual('TransportModeBV',1), Dual('TransportModeNOTBV',0)) as TB
Resident [Shipment];