Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

PLSQL to Alteryx

GalegO
7 - Meteor

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

1 REPLY 1
h_kleine
6 - Meteoroid

You could nest the replace function?

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

 

Or Find and Replace with a reference dataset?

 

Screenshot 2021-10-18 135417.png

Labels
Top Solution Authors