Status change

[Sra1bandi]

Hi team,

I have a field which is having field values  status= closed, open , ready , complete

The file is daily updating then the status will also change according to the change 

For example previously i have status= Ready now it's changed to Status= Complete 

In table status both  are displaying when it's updated 

I want only the status when it's updates to Status=Complete show only complete don't require status=Ready 

How to do that 

Thank and regards

Sra1

[saranyadurai]

Hi @Sra1bandi ,

I hope you have a Key field in the file. Based on that, you can use the Not Exists script function in your model.

Example:

Load 

Keyfield,

Status,

Keyfield&Status as LinkKey  <- Used to fetch the new updated value

FROM XXX; < - Newly updated file

Concatenate

Load 

Keyfield,

Status,

LinkKey  

FROM YYY where not exists (LinkKey ,LinkKey) ;

I hope it helps you !!!

Thanks !