Check naming conventions of columns

Hello,
I want to check if the name of the columns of a table respect some naming conventions (no space, no special character). I tried with a rule engine but i didnt succeed to parameter it. There is a special node for this problem or it is possible to do that with a rule engine ?
Thank you for the answer

You first must extract the column names into a table with the Extract Column Header node, than you can use the Rule Engine

Hi there,

you can also access column names in Column Expressions node with columnNames() :wink:

Br,
Ivan

3 Likes

thank you for your answers

2 Likes

Hi there @Rome998,

additionally, if intention is to remove/replace and not just detect what is not by convention you can use Column Rename (Regex) node :wink:

Br,
Ivan

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.