I'm using five Excel readers that are pulling the spreadsheet data from a REST endpoint (URL). The purpose of the model is to combine all five spreadsheets into one output. They have the same schema. The issue I'm running into, is that the spreadsheets will all have a variable number of rows from week-to-week and when I specify the Cell Range in the Reader Parameters as (*:) the writer is still including all of the blank rows below the data for each spreadsheet, so the final output has a chunk of data, blank space, chunk of data, blank space, etc. Is there any way around this?
Page 1 / 1
After reading you could use a Tester to test if <first attribute> "has a value" and write only records where this test passes.
After reading you could use a Tester to test if <first attribute> "has a value" and write only records where this test passes.