Dynamic validation on a table in oracle

[hima_shar]

Hi All,

I have a scenario.

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

Customer_id	Customer_name	Address	Phonenr
111	abc	xyz	981234567
222	def	pqr	987654321

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_name	Column_name	null_check	length_check	pattern_check
Tbl_Customer	Customer_id	Y	Y	Y
Tbl_Customer	Customer_name	Y	N	N
Tbl_Customer	Address	N	N	N
Tbl_Customer	Phonenr	Y	Y	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 solution]

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

[hima_shar]

Thanks Jimmy. It helps