Excel Reader can't read pivot columns

Hi,

When I reading the excel file with Excel Reader node , I can't see excel file pivot columns and column details on excel reader.  I can see only nonpivot columns and nonpivot columns data on excel reader preview. I want to read all columns which are pivot or nonpivot type.

 

 

Hi ncorbaci,

Which version of KNIME are you using? I have just tried to read an xlsx file with pivot columns and the Excel Reader (XLS) node reads them in the same way they appear in Excel. This is also the case if the sheet includes non-pivot columns as well. Can you please clarify what the issue is?

Cheers,

Roland