I'm trying to create a workflow for uploading/inserting data into a database by excel file. The current problem is how to validate the excel file or respecitvley the columns in it. The count must match as well as the naming. Also the matching should be case insensitive (like Database writer is).
Is there a node that helps with this? I only came up with a convoluted worklfow that seems far to complicated for the task.
Can you use the extract column header node followed by a transpose node. You can then count the number of rows with value counter node.
You could also use the reference column filter node with another dummy table which has your desired table structure. Choose the include filter.
Do these work for you.
Simon.
Reference Column filter is case sensitive on name.However I might just change requirements to make it simpler.