How can we help?

New post
0

Merged Modelled datasource Combining fields in calculations

Avatar
Joshua Kitz
None
Follow

Working with Modelled datasources.

I have merged two datasources together.

I would like to add a new column with a calculation that uses values from both of the datasources. I can use the "first" datasource, but not merged datasource in the calculation.

Am I missing something?

Being able to precalculate things in modelled datasources is a big win, not being able to do it with multiple merged datasources is an unfortunate limitation. (Right now my solution is to calculate them all as needed in the klips that use them -- which is quite a few.)

Date Votes

1 comment

  • 0
    Avatar
    Keely Davison

    Hi Joshua,

    Great question. You can do this in model using "results reference".

    To access the data in the 2nd data source  do

    &columnname

    where "columnname" is replaced by the name of the column in your model.  When you type the & you will be presented with a dropdown list of columns to pick from. 

    See this article on Results References for more details

    https://support.klipfolio.com/hc/en-us/articles/115000181613-Writing-formulas-using-results-references

    Hope this helps and if you have more questions just let us know.

    Keely

Please sign in to leave a comment.