Forum Discussion
Creating an automatic column
Hello !
As part of a professional project, I would need to create an automation for adding a column.
Let me explain.
Currently to create this column that does not exist on our dataset, we click on the new column button and we put a LookupV function with a formula that includes the table or we retrieve the information that will be in this column.
My manager wants me to optimize that, automating and making sure that when we refresh this column it increments.
Ideally it should avoid the manip create a column
Is there someting not working in your column? That will get updated every time the model is refreshed so new entries will be popuplated.
7 Replies
It sounds like you use the table in multiple datasets and you have to add this column each time, correct? You could create the table in a dataflow where you add the column as part of the transformation, then you would get the table from the dataflow for each new dataset and the column would already be there.
Please share an example of the two tables. Paste the text, not a screen shot of the tables. Show what field you are trying to add from one to another.
Is there someting not working in your column? That will get updated every time the model is refreshed so new entries will be popuplated.
Your LOOKUPVALUE column is the calculated column. Whenever the model is refreshed the calculated columns are re-calculated.