IF Statements

[danielnevitt]

Hi,

I am trying to create a field on the load statement that returns Y if the Payment Due Dt is < ReportDate else returns N.  This field can be named Overdue.

Is that possible?

Thanks,

Daniel

[MindaugasBacius · Accepted solution]

I suppose that both fields are in one table than in Script just insert one line like:

Load *

     ,If([Payment Due Dt] < ReportDate, 'Y', 'N') as Overdue

From YourTable;

[sunny_talwar]

Do you have Payment Due Dt and ReportDate in the same table? If you do, then it is as simple as doing this

If([Payment Due Dt] < ReportDate, 'Y', 'N') as Overdue

If they are not in the same table, you will have to somehow bring them in the same table....

[danielnevitt]

Thanks for your help