Forum Discussion

igaca's avatar
igaca
Icon for Helper III rankHelper III
8 years ago

ADDCOLUMNS - please explain!

Greetings folks!   I have a calculated table which contains two columns with date values.  Now I wish to generate another column which calculates their difference.   I am utilizing ADDCOLUMNS to ...
Need Help
Tutorial Requests
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI igaca

 

Rather than try and put the logic into your ADDCOLUMNS statement at the point you create the calculated table, why not just add a calculated column to the table once you have created it with the same logic?

 

 

igaca's avatar
igaca
Icon for Helper III rankHelper III
8 years ago

I already addressed the issue via a calculated column, am just trying to understand why no context transition is taking place (notice the value returned for each row is that of the entire table) to the ADDCOLUMNS (which is an iterator).

 

My guess is that this has something to do with the fact InputTable variable is a virtual table and does not physically map to the query-derived tables in the model but would love for someone who knows to explain what is actually going on.

 

Thanks for your input Phil.