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...
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