Visit the official Paxata Documentation portal for all of your doc needs.

How to handle nested functions in Paxata?

Hi everyone.

I'm working on a project where I need to create several new columns using the functions accessed through Compute.  I have hit a stumbling block in that I have to create a column in a way that seems to require two nested functions and I have not been able to do so successfully.  

The main function is IF.  There are two criteria that must be me for the IF, so I'm also using AND, that part has no problem.  However for the second criteria, there are two options out of six in the same column that need to be included.  So I need to have a nested OR.

Here's the equation using the IF AND; this works fine but it's not getting to the category that's being asked for.

If (And (left (column , 3) = "ANN", (column2 = "FINANCIAL INSTITUTIONS")), "ANN-FIW", "N")

This works fine but I also need for the second column to have another accepted value of "REGIONAL WIREHOUSE" along with "FINANCIAL INSTITUTIONS"   It seems like there must be a way to do this but I have met with repeated failures all day yesterday.  Does anyone have suggestions, instruction, or advice?

Thank you!

Best Answers

  • JRoodJRood Posts: 10
    Accepted Answer
    That makes excellent sense.  Thank you!  Still learning all the different options.  

Answers

  • Thank you!  That does help with that issue.  In continuing on, I have come across another hurdle.  I have four columns that I need to create a new column from based on the text in them.  The text isn't the same in any of them, and to be usable for the further work this is for, the fields in the new column have to read the same as the individual ones.

    So if Column 1 has ID and N, Column 2 had FW and N, Column 3 has LI and N, Column 4 has RP and N.  I need to make a Column 5 where ID, FW, LI, and RP all appear for the appropriate rows.  Any suggestions?  This one seems like a real doozy, so I get it if it needs to be approached a different way.
Sign In or Register to comment.