Export subset of data from Excel sheet xml

Occasional Visitor

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?

1 Reply

@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