To obtain data from each row of a Datamart (DM), use:UserEntry UserEntry("fieldName") and StringUserEntry("fieldName")
After running the logic in a Data Load, as it iterates through each row of the Target DM, itwill it will automatically access the Field Name parameter within the UserEntry("fieldName") formula.This This field value can then be used in the rest of the logic.
To add data to a field with calculation logic, give an element in your logic the same name as the as the target field in the DM and whatever is returned in that element will be inputted into that fieldin the input for that field in the DM when the logic is run.
To run the logic, create a new Data Load by hitting the 'Add' button and give it the same nameas name as the target DM with the type 'Calculation'. Go to the 'Target' tab and select a target DMfrom the DM from the drop down menu. You can filter the DM here so the logic will only be run on certainrows certain rows of the DM.
Go to the 'Calculation' tab and select your formula from the drop down menu.You You will see your inputs in the 'Formula Fixed Inputs' column. To test the formula, select a DMrow DM row in the 'Target' tab and click 'Test Formula' in the 'Calculation' tab. You will see the results in 'Formula Outputs' and 'Row Result' columns. You can click the save Save button to store your filter on filter on the DM and your formula. Click 'Run Now' to run the logic on the target DM.
...