Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Hi
Try below expression
IF(status = 'completed' or (match(status, 'low','High','Medium')>0 and not IsNull(date)),'completed',status)
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
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
Hi
Try below expression
IF(status = 'completed' or (match(status, 'low','High','Medium')>0 and not IsNull(date)),'completed',status)
Thanks to all.