Being more efficient with Multi Row?

Question

Hello There,

I am using the PDF tool to import documents which require tidying up and placing into the correct columns (I am aware of Intelligence Suite and PDF imports with tables it has a problem as noted already to Alteryx support) so I am using Multi row which works well. However I have a few questions

1) Is there a way to do multiple Expressions in the same step rather then needing seperate workflow boxes? IE

* If A then B else C EndIF
* If A1 then B1 else C1 EndIF

2) How do you use OR in Expression? IE I would normally write in other languages

* IF OR(A=1,B=2) then C else D EndIF

Thank you

atcodedog05 · Accepted Answer

Hi @Bobbins

You can define all these formulas in a single formula tool like below.

Hope this helps : )

Bobbins · Accepted Answer

😖Thank you, thats perfect, just a good reminder that sometimes a tool that starts off as the right one may not be the right one when you finish getting what you want out of it

Thank you

gabrielvilella · Accepted Answer

Hi @Bobbins, you can have IF statements in another IF or IFELSE statements, such as:

IF A
THEN
   IF AA
   THEN BB
   ELSE CC
   ENDIF
ELSE B
ENDIF

IF A
THEN B
ELSEIF C
THEN D
ELSE E
ENDIF

For the OR statement, here is how:

IF A=1 OR B=2
THEN C
ELSE F
ENDIF