Forum Discussion
Export subset of data from Excel sheet xml
Hello All, I have an excel sheet with data, I have added a schema on Developer -> Sources. I am able to export data from the sheet as per my schema mapping. Now, I do not want to export all ...
Are you familiar with the relatively new FILTER function? In case you're not, here's a YouTube video with a Microsoft developer explaining it. It should enable you to extract based on your criteria, extract to a separate sheet, and then export in a normal fashion.
https://www.youtube.com/watch?v=9I9DtFOVPIg