Excel data validation
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.