Hi Community,
I've a case as below:
Table:
How can I dynamically replace [Field1] and [Field2] values on Field Output?
If I'm using table above as input data, after workflow running, the output should be:
Please note that number of reference Field (Field1, Field2) and output combination can be changed based on user input.
Thank you.
Best Regards,
Luqman
Solved! Go to Solution.
Hi @luqmantmf
This can be achieved with the help of Regex/Text to columns tool.
Then use the formula tool to achieve the output.
Many thanks
Shanker V
@ShankerV How is this helpful if you don't rpovide the regex or formula to complete the task? You might as well reply with "This can be achieved using some Alteryx Tools"
Hi @luqmantmf
There are many ways to do this as @PhilipMannering also suggested a way to do this.
I was trying to save the workflow, however was throwing an error. Below are my steps to achieve the solution with 2 tools.
Output:
Step 1: Input
Step 2:
Step 3:
IF [Field Output1]=[F1]
THEN [Field1]
ELSE [Field2]
ENDIF
IF [Field Output2]=[F2]
THEN [Field1]
ELSE [Field2]
ENDIF
[Field Output1]+", "+[Field Output2]
Step 4: Remove unwanted columns
Many thanks
Shanker V
@ShankerV Fair enough. Apologies!
Thank you very much @ShankerV and @PhilipMannering.
I've got the concept how to perform the action.