Tutorials & Examples Web-help Blog

Getting function expression as values in column


#1

Hi Dmitry,

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?

Thanks !


#2

You can create columns with generic names and then rename them using the “Rename with lookup” action.

Capturing expressions is not possible, unless you load and parse a .morph project using the “Import from XML” action.