Forum Discussion
Pro User needs to increment data from excel
I have exel table A and table B. Each day table B updates with new data. Steps I want to take: Day 1 Append B to A A + B becomes a new data set C Day 2 Append updated B to new data set ...
I'm thinking you could just use the Import from folder feature. Then just drop the new csv file in that folder and refresh. Let Power Query do the heavy lifting of mashing it into one table.
I'm thinking you could just use the Import from folder feature. Then just drop the new csv file in that folder and refresh. Let Power Query do the heavy lifting of mashing it into one table.