Data Preparation

[Zaid]

Hi All,

There is a scenario which I wauld want to replicate using Alteryx. I am having an input like :

ID	Value
1	>=5
1	>=1(>=4)
1	N/A(<=5)
1	<=5%(<=6%)

The requirement is such that, i would want to consider the values that are present inside the parentheses as well as one of the values against my particular id. SO the desires output should be something similar to the one shown shown below.

ID	Value
1	>=5
1	>=1
1	>=4
1	N/A
1	<=5
1	<=5%
1	<=6%

Please reach out if there are further questions. The logic should be able to handle nulls and alphabets as well as shown (N/A) in the Value column.

[itestu · Accepted solution]

Hi,

See my solution enclosed.

2 main tools I used : Text to column, Transpose tool.

Have fun !