Load only desired sheet from multi-sheet excel workbook?

asked 2020-09-17 09:22:46 -0600

anonymous user

Anonymous

Using a directory origin, glob pattern, my pipeline successfully moves data from excel source into target RDBMS. However, the workbook has multiple sheets whereas I only need to one. I am manually removing the unwanted sheets before calling streamsets.

But i am wondering if directory origin has a way to only process desired sheets or only 1 sheet? I read documentation and only found topics on latest timestamp but nothing on moving only 1 or a subset of the whole for sheets in excel workbooks.

edit retag flag offensive close merge delete