In our data quality checks I create a lot of additional columns (e.g. 100 columns) with the checks to be done.
One problem is that I cannot see how to make the naming of the columns dynamic.
Is there a way to create these columns in a dynamic way, e.g. CONTROL_1, CONTROL_2 and at the same time adding in another column a discription of the quality check or capturing the expression from the formula editor that checks the data ?
The purpose is to create a metadata sheet of all data quality checks performed so that I can append it to the report?