Forum Discussion

tejesh1987's avatar
tejesh1987
Copper Contributor
Jun 28, 2022

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 10000 rows in my excel to xml, I just want to export just few rows based on a filter.  How can I export this subset?

developer
excel
  • mathetes's avatar
    mathetes
    Silver Contributor
    Jun 28, 2022

    tejesh1987 

     

    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

     

Resources