script help

[aaronnayan]

Hi Guys

I am in the script editor and loading a table file with fields. i only want data to load with certain values based on one of the fields conditions.

Custno

Flag4

i want all customers to load that Flag4 = Y  (yes)

I did think to put a where clause but it is not working unfortunately

Sorry this may sound confusing, please ask if you need more info i am really struggling

Many Thankssss

[Peter_Cammaert]

Maybe:

Table:

LOAD *

FROM TableFile (options)

WHERE UPPER(Flag4) = 'Y';

[Anil_Babu_Samineni]

May be missed Single Quote like Where Flag = 'Y'

Or else you could share full screen