I want to shift columns information from “Data Extract” excel to “Main Database” excel. “Main Database” excel columns’ have already some existing information, which I can’t delete or alter. “Data Extract” yellow marked 8 no columns data need to be shifted to “Main Database” 8 no columns. Problem is “Main Database” 8 columns are not located together, rather they are separated by some other columns, which have some default value.
I can copy each columns of “Extract Data” excel file by “read range” activity & store them in different data table but how can i write them in already filled columns of “Main Database” file.
For your convenience/better understanding, I am attaching column name files and “Extract Data” & “Main Database” excel file.