PLSQL to Alteryx

[GalegO]

Hi all,

What's the best method to translate a query in PLSQL to Alteryx?

For example, I have a big query with a lot of PLSQL functions, like this one (as example):

max(trim(replace(replace(translate(table.column,'A,','A '),chr(13),' '),chr(10),' ')))

I think I can use a formula tool and use some functions to simulate the same output:

- For the replaces, I can use the REGEX_Replace() with \r and \n

- For the Trim, we also have the Trim

But, What I can use for translate (https://www.techonthenet.com/oracle/functions/translate.php) and max (https://www.techonthenet.com/oracle/functions/max.php)?

Or is there any other way to do this?

PS: The workflow will connect and consume the information directly from the database.

Thank you

[h_kleine]

You could nest the replace function?

replace(replace(replace([Field1], "1" , "4"), "2", "5"),"3", "6")

Or Find and Replace with a reference dataset?