Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Updating the existing field after particular date.

Hi all ,

i need some help. have to do some changes in the existing application. the requirement is like some changes has done in the object id and the business unit. so the user wants that  the changes should be reflected only after the 1st Nov 2013 data in all the reports and dashboards.

The new data is given in the excel file, in that there is old object id , new object id. and old business unit and new business unit.

the sample excel is also attached for the reference.

.

1 Reply
salto
Specialist II
Specialist II

Hi,

Check the transaction date in the load script.

If the date is higher than 1/11/2013, set the ObjectID and BusinessUnitID to the appropriate values.

Hope this helps.