This is CROSS POSTING!!
Happy new year!!!!!
I have a master data file where data is changing under three categories for every financial period. Now, for each category, I have separate files (Apple, Mango, Lichi) to update them for the current period. As of now, data is updated till period 11, however, I have the latest data for period 12. I want the category table should be updated as per the data mentioned in the Master data file. Like if the Master data file has 5 rows for the Apple category the data should go to the Apple file by inserting 5 rows in the table ( TABLE format should be unchanged) and also file should be renamed as per year and period like mentioned naming convention. Like, for period 11 it is mentioned as Apple_202011 and for 12 it will be Apple_202012.
Files are attached for your ready reference.