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, suggest an easy and best way to tackle this issue. What I tried so far but not succeed. In a new excel file from Data ribbon Existing connection pulled data but again when refreshed lost cleaned data In a new excel file Data ribbon New Query pulled data cleansed but lost after refresh... I wanted to have pull and work in the same sheet apparently it doesn't work in this way... Maybe I need a pulling data and work table data but how to get only new submission by using Power Query? What would you suggest? Many thanks, Amriddin