Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe:
Table:
LOAD *
FROM TableFile (options)
WHERE UPPER(Flag4) = 'Y';
May be missed Single Quote like Where Flag = 'Y'
Or else you could share full screen