Field name
Hi All,
I am defining new formula for 100 columns. Everytime i define the formula execution happen and later i have to manually rename the column. for example if on Col A i define a formula as groupsum(amt) the resulting may be total_amt. instead if i want that column to be named as Total_Amount, the only option i see is i am renaming again and execution happen and this is time consuming. Instead would like to know whether we can define the column name along with formula. for example Total_amount = groupsum(amt)
thanks is advance
-
Hello Ganesh.
There are three possible variants of a column name after a formula is applied.- It will not change.
- It will change to the name of a column you refer to.
- It will change to describe the result better, using the hardcoded SuggestColumnName logic. E.g., after applying the GROUPSUM function, the column name will be Total_<ColumnName the function is applied to>, or for the HOUR function, the column name will be Hour.
the only option i see is i am renaming again and execution happen and this is time consuming.
The Workbook is not being executed when a formula is applied. You introduce the formula, press the Apply button, and you should see the result applied to the data sample right away. At this point, you could change the column's name.
An alternative approach is to create the desired transformation using default columns names, download the JSON definition of the Workbook, change column names in this file, and update the Workbook via REST API. Please refer to the REST API Workbook section of Datameer documentation for more details.
Do not hesitate to let me know if you have any further questions.
Please sign in to leave a comment.
Comments
1 comment