Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't get the following to work:
If((
(Rate_Index = 02 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000, 0.002000, 0.003000)) or
(Rate_Index = 03 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000)) or
(Rate_Index = 04 and Not Wildmatch(Interest_Rate, 0.001000, 0.002000, 0.003000, 0.005000)) or
(Rate_Index = 07 and Not Wildmatch(Interest_Rate, 0.000000, 0.001000)) or
(Rate_Index = 08 and Not Wildmatch(Interest_Rate, 0.001000)) or
(Rate_Index = 13 and Not Wildmatch(Interest_Rate, 0.010000, 0.001500)) or
(Rate_Index = 34 and Not Wildmatch(Interest_Rate, 0.001000, 0.003000))), 1, 0) as Error_Interest_Rate,
I have this in the Load statement. I have tried using " ' " doesn't help. It appears to give everything a '1', regardless of Interest_Rate.
Thanks
That makes sense, unfortunately I'm not allowed to upload any data.
you're not allowed to upload 10 rows of the fields Rate_Index and Interest_Rate?!?
LOL I meant my employer. They are really strict, I was luck to get them to let me post what I did.