Dynamic validation on a table in oracle

Question

Hi All,

I have a scenario.

I have a source table named Tbl_Customer in oracle like below.

Customer_idCustomer_nameAddressPhonenr111abcxyz981234567222defpqr987654321

I have to put some validations like null checks, length checks, pattern_checks on these source columns. however we have a reference table to decide which column will have what check. just like below.

Table_nameColumn_namenull_checklength_checkpattern_checkTbl_CustomerCustomer_idYYYTbl_CustomerCustomer_nameYNNTbl_CustomerAddressNNNTbl_CustomerPhonenrYY N

Here Y means we have to put that check, N means check not required for that column.

Can someone please help me achieve this in Alteryx? What steps and set of tools should I use so that my workflow dynamically check for validations specified in the reference table?

Regards

Himanshu

jrgo · Accepted Answer

Hi @hima_shar,

Some tools you can try is the Field Summary tool (Data Investigation category). This is actually a macro that you can open up if needed to get a better understanding of what it's doing and customize if needed. The Dynamic Replace is also pretty versatile tool that. Hard to explain, but allows you to create dynamically generated expressions and apply them to fields if a bool condition is met.

Hope this gives you some ideas!

Best,

Jimmy