Dynamic Expressions in Automation

[thomas]

Hi all,

I’m new to Foundry and trying to use automate for the following:

1. Run over all of a particular object type and see if the value of a particular property is in certain ranges
2. Create a new object of a different type, with its properties based on the range of the original object’s property

For example, look at every object of type XYZ, and make an object of type ABC with property a being set based on property b in XYZ.

I’ve tried using:
Condition: Run on all objects
Action: Create object

But then the options for the parameters for that action seem just to be static, or just the exact value of a property in the original object.

Thanks in advance for any assistance

[lrhyne]

Welcome to Foundry

This sounds more like a data pipeline than an automation; feel free to share more specifics, but I would set up a Pipeline Builder pipeline starting from the input dataset (assuming no edits; use the materialization dataset if there are edits) for object type XYZ.

Do your filtering and any other transformation necessary and then create an output dataset (or directly create the Object Type ABC) from Pipeline Builder.

You can then schedule this pipeline to run whenever the input dataset is updated, so they stay up to date.