Machine generate ID field

[s2016]

Hi,

I have daily QVD files such as Entity_10/6/2917 with fields [entity, date, capacity, total_volume].

Each day some new entities could be present in these QVD's and also the capacity of previous ones could change.

I need to generate a unique entity_id field for each entity and also the below date and status fields.

Entity_Status_Flag	Entity_Creation_Date	Entity_Status_Change_Date	Entity_Last_Read_Date
"I" initially	Date when entity first appeared	date of last capacity change to this record	date of last apperance in the Entity files
unchanged unless last read data is >7 days ago

Could you please help me with the script to create these fields.

[s2016]

I am basically trying to create a single QVD file which has a unique row for each entity with latest capacity.

The total_volume field can be ignored.

[Siva_Sankar]

Hi Shashank,

try this example Load only fields where date is max date | Qlik Community

and Obtaining last field based on max(date) in same... | Qlik Community

and Load Record with Max value only

-Siva