Spreadsheet reader - exclude 1 sheet

CloverDX Platform
1

Hi,
I am using Spreadsheet reader component to read a dynamically created xls file.To read data from all the sheets we use ?* in the sheet attribute.Is there some way so that i can read all sheets except the 1st sheet.

2

Hi Raphael,

Unfortunately you can’t provide such mask for SpreadsheetReader. I see 2 options:

  • Using JobFlows repeatedly pass parameter into graph which reads exactly one sheet - given by parameter. Then aggregate read data.

  • If all sheets share metadata you can read data of all sheets. Add one extra field into metadata using Autofilling Functions, namely “sheet_name”. Then filter output records on this field - so you get only interesting sheets.

I hope this helps.