I have a data table with only one column containing certain data. I have used an add data column activity to add a new column to this data table.
Now, I want to insert pre-calculated values to the newly added data column based on the data in the first column.
I created a workflow using some expressions but that doesn’t seem to be working as I wanted it to.
Say, if it’s Code_A then I have calculated value that goes adjacent to this cell.
Here’s a screenshot for your reference of what I’m trying to achieve:
Kindly help me with this!