Hi folks, I’ve read a lot of answers here, and I think the best option here would involve FormulaMap. In typical software dev, I would use a basic for loop.
Foreach row in Hello!, get the contents of the column “Original”. Do some transformations to that data, then paste the output to the “Output” column (in this case, transformation is replacing some text fields using RegexReplace)
The closest I’ve come is the following, but this of course gets all columns of the “Hello!” table
@John_John,
You can accomplish this with the Format() formula.
something along the lines of: Hi {1}, I hope you’re having a great {2}!
then in your [Output] you just add a formula with Format([Original], Input.[Customer Name], Input.[Day])
As seen in the doc below.