Better if you can share sample? You need to show on file base names but when i see concatenate.qvd. There is 2018-1 which is Max but where 2018-2 is 300 but your output seems 180? Can we know the reason behind
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
the reason behind why in the expected output the price of ITEMCODE is 180 since it its the latest datecreated...
this is the mechanism in our database it change on a daily basis, so i need to change the data base into the latest DateCreated, i need to retain the old values in case there are items in the old extracted file is not duplicated when i concatenate the latest extracted.