Transformations improvement

In order to make yourtransformations easier, we haveadded new functionalities so that you can make the best of Simetrikin your daily work.

Identify columns that are blank:

Step 1. Insert a transformation column and select the function "ISBLANK".

Step 2. Select the column with which you will perform the validation.

Step 3. Confirm the formula and you can validate the transformation column added at the end, it will indicate in "True" the records that you have blank and in false the records that do contain information.

Now the transformations have clearer and more explanatory texts in which you will have a more accurate guide on how to execute the transformation of your choice:

Comparison with dates to know if the record corresponds to an earlier or older date.

Step 1. Select the If(

Step 2. Select the Date column you want to evaluate.

Step 3. Use the greater (>) or lesser (<) sign according to your need.

Step 4. Between quotation marks you put the date to which you are going to compare the column.

Step 5. Finally you put the parameter that it should have if it is valid and the parameter when it is not valid.