I'm trying to convert a string of logical operators to alteryx readable operators. Below is an example of what I have in a string field:
OR(AND([Field1]==0,[Field2]!=0),AND([Field1]>=[Field3],!(AND([Field1]==0,[Field4]==0, [Field6]>0))))
I need to figure out a way to transform the above, using formulas or some other tools, to be similar to how Alteryx likes logic and still store it in a string:
(([Field1]==0 && [Field2]!=0) ||([Field1]>=[Field3] && !(([Field1]==0 && [Field4]==0 && [Field6]>0))))
I can see how to do this manually, and what I am struggling with is how to use some functionality in Alteryx to convert the input to the output. I receive hundreds of these logical strings on a spreadsheet, and I know how to assign them provided I can convert the logic to and Alteryx friendly version.
Any help would be greatly appreciated.