I have database (csv) of the albums, with %index% as the unique record locator for each album. The same index is added to music collection with record locator %index%.
Now, in the database (csv) as I have %index%;%year%;%composer%.
I want to batch process the the entire collection to update %year% and %composer%, using %index% as the record locator in the music collection, instead of %_filename_ext% as the record locator. (music collection already has the %index%)
I can do work around, I can output the entire collection with %_filename_ext%;%index% to csv and merge (vlookup in excel) this file with main database to obtain %_filename_ext%;%index%;%year%;%composer%
But this would add additional step everytime, there is change in input database and additional record.
If there is a way to use %index% as the record locator, then it will easy solution.