Replace a String in a Column with Other Column Value

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

Dynamic Processing

Accepted answers

philipmannering

Something like this should work,

replace a string in a column.yxmd

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

All comments

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

philipmannering

Something like this should work,

replace a string in a column.yxmd

philipmannering

@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"

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

philipmannering

@ShankerV Fair enough. Apologies!

Thank you very much @ShankerV and @PhilipMannering.

I've got the concept how to perform the action.

Quick Links

Tags

This months top contributors

Hollingsworth 335