topic Re: Machine generate ID field in QlikView

Machine generate ID field

s2016 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 12 Jun 2017 02:51:59 GMT

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 — Mon, 12 Jun 2017 03:08:42 GMT

Hi Shashank,

-Siva