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?
Solved
Limit a variable end range of an Excel Reader
Best answer by erik_jan
After reading you could use a Tester to test if <first attribute> "has a value" and write only records where this test passes.
+17- Contributor
- Best Answer
After reading you could use a Tester to test if <first attribute> "has a value" and write only records where this test passes.
erik_jan wrote:
After reading you could use a Tester to test if <first attribute> "has a value" and write only records where this test passes.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.