GitHub user hansva added a comment to the discussion: Validate .xlsx headers and abort if required fields are missing
The trick to do this is to create generic fieldnames, just give them number 1 -> 50 if you expect a maximum of 50 columns. In the Sheets tab, you set the start row to -1 and in the content tab you set the limit to 1 row. If you do this, you will get a single row containing the field names. I usually then follow up with a Row Normaliser to transpose the columns to rows, and then you can compare to your validation set GitHub link: https://github.com/apache/hop/discussions/5180#discussioncomment-12839973 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
