Exchange of data between 2 data sets

To be completed by the original poster:

CMS Version

Version 3.1.0 (RUNNING ON DOCKER)

Player Type



I have 2 datasets,

dataset_3 - with column names - Name, Status.
dataset_4 - with column names Status

I want to pick the dataset value of the column “Status” based on a specific name (for example-Mukul) and put the value in Dataset_4 column Status.

This is what I have done:

Create the “status” column in dataset_4 as “Formula” and added the formula "Select Status from dataset_3 WHERE Name=“mukul”;

Somehow I am not able to get it working. Can somebody please guide me in the right direction to get this done?


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.