Forum Discussion
How to connect excel sheet to get only new submission
Hello! I used Excel Power Query to pull data from KoboToolbox. I did data cleaning in the same file and when refreshed to get new submission my cleansed data refreshed as well. Could you please, sug...
Hi Amriddin,
Power Query is designed so that clicking Refresh goes back to the source file and pulls in all of the data and replaces any existing loaded data.
You may want to consider copying and pasting (as values) the loaded cleansed data into another table after each refresh in order to keep the history.
Power Query is designed so that clicking Refresh goes back to the source file and pulls in all of the data and replaces any existing loaded data.
You may want to consider copying and pasting (as values) the loaded cleansed data into another table after each refresh in order to keep the history.
Thanks Wyn! Yes you are right, but i want to have this process automatic other wise i will go crazy copy/pasting after each cleaning into another table. It seems VBA skills needs to be applied for this no (unfortunately i don't have that skill)? Or is there any possibility to find out new submissions while refreshing in Power Query and if there are new submission then merge it working table....
Yes VBA would definitely be the best route.
It is possible to do a self referencing query in 2 stages but I could imagine it might be difficult to manage.
See attached