column missing while reading the data

[Subramanyam]

Hi Team,

I am reading the data from an excel sheet using KNIME excel reader but unfortunately one column is missing after reading is completed.
this is causing the logic failure in the workflow.

attached the excel file and the column missing is “JNJ Sls Form/Flavor”

Please suggest me in solving the issue.

Thanks,
Subbu
JNJ Current Vulnerability Report - 2025-04-29.xlsx (77.2 KB)

[MartinDDDD]

I tried and cannot replicate the behavior you are describing - after initial load w/o any config changes the column shows:

When I then make that row a column header it also works:

Here is the workflow.

missingCols.knwf (149.4 KB)

Can you export the workflow where you encounter this issue?

[Subramanyam]

Please find the attached workflow and the excel file is same as above
Datamodel.knwf (125.7 KB)

[MartinDDDD]

Well given that I cannot access the file system it is hard to tell.

My best guess is that certain columns in your source file are hidden (either hidden in Excel by right-click => hide or they have been grouped and are collapsed).

I suggest to change the following settings.

I’d also recommend you check if you are free to share all this stuff on a public forum… dont have the feeling this is “dummy data”… of course entirely up to you what you do.