Jump to content
We've recently updated our Privacy Statement, available here. ×

Reference another dataset in a calculated column without combining them


Recommended Posts

Hi everyone,

I have a dataset like this:

 

 

 

KEY

Threshold

 

 

1

2.1

 

 

2

2.3

 

 

3

2.5

 

 

 

Then I have another dataset with lots of entries, and I need a calculated column that takes the filtered KEY(only one at a time) in order to retrieve the threshold and calculate the final value.

I know that there is a possibility for this, but it would triplicating the entries in my other dataframe so that there will be one entry for each KEY, but this would make my dataset huge.

Is there a way to get the threshold from the other dataframe without combining them

If not, would it be possible to create variables or constants that change when a KEY is filtered

Thank you very much.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...