Analytical App - Choose fields to cleanse and replace nulls and remove unwanted characters

[wonka1234]

Hi,

Is there a dynamic way in an analytical app to choose which fields to cleans and which options to choose in the clean tool?

[martinding · Accepted solution]

Hi @wonka1234 ,

Here's one way to do it.

I've provided examples for:

1) Letting the user select the fields they want to cleanse

2) Letting the user select whether to replace nulls with blanks.

You can essentially adopt this to include any of the available options in the Cleanse tool.

Hope this helps!

[wonka1234]

@martinding thanks! so the user would have to type in the columns to cleanse?

[martinding]

Hi @wonka1234 ,

Yeah, that's one way to do it. There are other ways, let me get back to you later, a bit busy with work at the moment sorry😂

[martinding · Accepted solution]

Hi @wonka1234 ,

Please find attached a list box version where the user can select a column to cleanse by ticking the corresponding box.

[wonka1234]

@martinding 

How do you know which each of these values apply to in the data cleanse tool?

I want to add more features to your tool.. ie not just replacing null with blank, but more!

[martinding]

Hi @wonka1234 ,

I believe the Cleanse tool is a macro, and if you right click on the Cleanse tool icon, you should be able to open up the macro.

Once opened, you should be able to see which Check Box correspond to which option in the Cleanse tool.

[wonka1234]

@martinding  I think your workflow doesnt work, i see in the tool the selections are already checked, shouldnt these be unchecked and then in the analytic wizard wand tool to select them and then it will replace nulls? 

do things need to be already checked off?