Being more efficient with Multi Row?

[Bobbins]

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 solution]

Hi @Bobbins 

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

Hope this helps : )

[Bobbins · Accepted solution]

😖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 solution]

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

[atcodedog05]

Happy to help : ) @Bobbins 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!

[Bobbins]

Thanks @gabrielvilella I knew you could nestle IF statements but normally only when they are talking the same problem. The single use of formula will mean i will keep them separate (helps tinkering). Also thank you for OR structure.