Hi All,
I have a cross tab report report for months (Month name as column headers) .After the cross tab tool I had used Data cleansing tool for the respective months to replace Null with Zero.
But with the addition of a new month, the data cleansing tool doesn't add the new month dynamically.I tried using a select before the data cleansing tool, it didn't work.
I came across this link https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Adding-Unknown-Field-Checkbox-to-Data-Cleans... on Community, this is listed as an idea.
Let me know if there is any workaround for this.Thank You.
Regards,
Rahul
Solved! Go to Solution.
The Data Cleanse tool is a macro. One option would be to open it, save your own copy and edit or build your own version to always includes all fields. Right-click on the Data Cleanse in the toolbar to open the macro. It might be as simple at removing the List Box from the interface.
Hi @KOBoyle,
I tried creating a new macro from Data Cleansing and cleaning up but was not successful in applying the changes dynamically to the new month data that comes in.
Have you tried this before, removing the interface list box didn't help.Thanks.
Regards,
Rahul.
Hi All,
The technique of creating a new Macro for data cleansing works from my machine.
But as soon as it is run from the virtual machine via a scheduler, it fails to recognize the Macro and fails.
Do we have any alternative technique here.
Thanks.
Regards,
Rahul