•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PowerQuery Import: APPEND records from source file instead of replacing
I have an excel file that links to and imports records via Power Query from a source file that I receive every week. I use my own excel file to transform the data from the source file without having to manually do so every week. When I refresh my, it pulls in new records and removes the old. Is it possible to just pull in the new records into my file and not have old records (no longer on source file) fall off my file?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Power Query
#Excel
#import records
#source file
#append records
#transform data
#refresh
#new records
#manual process
#weekly update
#remove old records
#data transformation