how to pick up all data from merged cells in an excel file
I have an excel file that contains rows which have merged cells for a few of the columns. When a pipeline is created for this file, it seems to pick up some of the data but not all- data that is missing is the rows that contain merged cells.
is there any workaround for this?
thanks
Sounds like there's maybe a bug in the Excel parser. Could you file an issue at issues.streamsets.com with the details?