IF CONDITION

[#1]

Hi to all,

Tab:

Key,

PartnerCodeTimeliness,

  FeedDateTimeliness,

  //max(FileReceivedTimeStampPMCTTemp) AS FileReceivedTimeStampPMCT,

  if(IsNothingToReportTimeliness = 0, 'Nothing to Report',

  if(RawRecordsTotalPMCTTemp = DeletedRecordsTotalPMCTTemp,'Deleted',

  if(IsNull(FileReceivedTimeStampPMCTTemp) and FiscalWeekEndDateTimeliness-now()>=Timestamp#('24:00:00','hh:mm:ss'),'Not Yet Due',

  if(IsNull(BatchIDCountTimeliness) ,

   if(ExpectedDateTimeTimeliness1>=now() ,

      if(ExpectedDateTimeTimeliness1-now()<=Timestamp#('24:00:00','hh:mm:ss'),'Due Shortly',

      //,'Not Yet Due2'),

         if(ExpectedDateTimeTimeliness1>=if(IsNull(GracePeriod1DateTimePMCTTemp),ExpectedDateTimeTimeliness1,GracePeriod1DateTimePMCTTemp),'Overdue',

            if(ExpectedDateTimeTimeliness1>=if(IsNull(GracePeriod2DateTimePMCTTemp),ExpectedDateTimeTimeliness1,GracePeriod1DateTimePMCTTemp),'Overdue',

               if(ExpectedDateTimeTimeliness1>=if(IsNull(GracePeriod3DateTimePMCTTemp),ExpectedDateTimeTimeliness1,GracePeriod1DateTimePMCTTemp),'Overdue','Not Received'))))), //NotReceivedStatus     

//ZAP-754, When no entry in Timeliness Master then On-Time is shown.

// if(BatchIDCountTimeliness < ExpectedFileCountTimeliness,'Partially Received',if(FileReceivedTimeStampPMCTTemp<= if(IsNull(ExpectedDateTimeTimeliness1) ,FileReceivedTimeStampPMCTTemp,ExpectedDateTimeTimeliness1 ),  'On Time',

// if(BatchIDCountTimeliness < ExpectedFileCountTimeliness,'Partially Received',if(FileReceivedTimeStampPMCTTemp<= ExpectedDateTimeTimeliness1,if(applymap('TimeLinessTrackerMasterMap',PartnerCodeTimeliness)<>1,null(),'On Time'),

  if(BatchIDCountTimeliness < ExpectedFileCountTimeliness,'Partially Received',if(FileReceivedTimeStampPMCTTemp<= if(IsNull(ExpectedDateTimeTimeliness1) ,FileReceivedTimeStampPMCTTemp,ExpectedDateTimeTimeliness1 ), 'On Time',

    if(FileReceivedTimeStampPMCTTemp<= if(IsNull(GracePeriod1DateTimePMCTTemp),if(IsNull(ExpectedDateTimeTimeliness1) ,FileReceivedTimeStampPMCTTemp,ExpectedDateTimeTimeliness1 ),GracePeriod1DateTimePMCTTemp) , 'In Grace Period',

       if(FileReceivedTimeStampPMCTTemp<=if(IsNull(GracePeriod2DateTimePMCTTemp),if(IsNull(ExpectedDateTimeTimeliness1) ,FileReceivedTimeStampPMCTTemp,ExpectedDateTimeTimeliness1 ),GracePeriod2DateTimePMCTTemp),'In Grace Period',

         if(FileReceivedTimeStampPMCTTemp<=GracePeriod3DateTimePMCTTemp ,'In Grace Period' , if(not IsNull(FileReceivedTimeStampPMCTTemp),'Late')))))

         )) //ReceivedStatus,

  ))) as FileUpdateStatus,

  ExpectedDateTimeTimeliness1,

  ExpectedDateTimeTimeliness,

FROM tab;

--------------------------------------------------------------------------------------------

For 9th MAR 2016 and  8th MAR 2016,It should return 'Not Yet Due',But it will give 'Not Received',

How Can i Achieve that.

Is there any alternate to write this much of code ???, if YES please let me know.

Can we use Set Analysis ??

please give valuable suggestions.

Regards

Prathap

[swuehl]

"For 9th MAR 2016 and  8th MAR 2016,It should return 'Not Yet Due',But it will give 'Not Received',

How Can i Achieve that."

I don't understand to which field these date values are referring. Please post a sample QVW in combination with some input records.

"Is there any alternate to write this much of code ???, if YES please let me know."

Maybe? But hard to answer without knowing the data model, input records, requirements.

"Can we use Set Analysis ??"

No, not in the script.