I’m looking for a good way to randomly from a table insert values in to a main string, something like:
This is $value1$ sentence and lets make it $value2$.
My input data in to this looks like:
RowID Value1 Value2
1 Good Larger
2 Nice Bigger
3 Cool Better
For each record I would like a function to randomly pick any Value1/2 value regardless of row ID so that the output could be:
RowID 1: This is nice sentence and lets make it better or
RowID 2: This is nice sentence and lets make it larger or
RowID 3: This is good sentence and lets make it better
I’ve tried to use this function in the String Manipulation node but I can’t seem to work how to randomise the $Value1$ and “Value2” in the function:
join("This is a ", $Value1$, ". Let’s make it ", $Value2$)
Any help is hugely appreciated.