Description

How to use transforms in Query

Applies to

Transform and write values to a new cell, Transform and write values in existing mapping

Solution

Transform and write values to a new cell

1. From the mapper select the transform button

 

2. Enter your transformation rule and the cell for which you'd like the formula to write to and select OK

 

3. You will see the formula output written to the Excel file in the specified column during run

Transform and write values to an existing cell:

1.From the mapper select the transform button

 

2.Enter your transformation rule and the cell for which you'd like to evaluate the formula, select transform original mapping, select OK
Note: The cell must be an unmapped cell that the script can use to evaluate the formula. The script will write the results back into the original cell mapping.

 

3.  You will see the formula output to the original mapped cell