We are reading excel file folder from List Files/Folder Node
Converting the folder path from previous node to variable using Table Row to Variable Loop Start Node
Reading the excel files using variable path in Excel Reader Node
How do I form workflow nodes after excel reader node.
I have 3 rows and 10 columns where each row has whether the
column is optional or mandatory in row 1,
column has alphanumeric or decimal or numeric or date with fixed length for each column in row 2,
and actual column name in row 3
and data in row 4.
Have to admit it is very hard to follow where your issue lies. I think your best chance to get help here is if you can create an anonymised, simplified example that includes WF input and desired output and describes the logic…
We need to validate the excel file by
checking the Length of row data from length from header,
check column duplicates, date format in row data,
string or integer as given in column header,
mandatory or optional. Below image is the input excel format.
I need suggestion to construct a workflow in KNIME to do all these after Excel Reader node.
Assume I will get multiple excel file as input from folder and each excel has different column counts as well. I’ll provide a sample image of the excel data.
It looks like something went wrong with your image. Usually it is best to provide mock up data as people are less inclined in building a prototype workflow if they have to start by typing data from an image into a file they can then read…
