Need logic during load statement

[#1]

Hi All,

Need logic during load statement as below.

Load Date,

          Status,

If (status = ‘completed’ keep same.

If status = ‘low’ and date is not null ‘Completed’ else ‘low’

If status = ‘High and date is not null ‘Completed’ else ‘High

If status = ‘Medium and date is not null ‘Completed’ else ‘Medium’) as NEW STATUS,

[MK_QSL]

IF(status = 'completed',status,

     IF(status = 'low' and not IsNull(date),'completed',

          IF(status = 'low' and IsNull(date),'low',

             IF(status = 'High' and not IsNull(date),'completed',

                    IF(status = 'High' and IsNull(date),'High',

                               IF(status = 'Medium' and not IsNull(date),'completed',

                                   IF(status = 'Medium' and IsNull(date),'Medium'))))))) as NEW STATUS

[crusader_]

Hi,

Load

     Date,

          Status,

     if(match(status,'completed'), status,

          if( match(status,'low') and not isnull(Date), 'low',

                    if( match(status,'High ') and not isnull(Date), 'High',

                         if( match(status,'Medium ') and not isnull(Date), 'Medium'

                              )

                    )

               )

     ) as NEW_STATUS

You definetely should have some TaskId, pls share your data sample.

HTH

Andrei

[perumal_41 · Accepted solution]

Hi

Try below expression

IF(status = 'completed' or (match(status, 'low','High','Medium')>0 and not IsNull(date)),'completed',status)

[#5]

Thanks to all.