Hi all, I have an issue with the data cleansing tool which delete all the data of the input and thus I have no more data in th output. Do you know what can it be? thank you
Can you share a screenshot for us to better understand the issue?
See what you have checked under "remove unwanted characters" in the Data Cleansing tool...
You may have "numbers" and "letters" checked so you would be removing those from your data...
Above is what I selected in the tool.
Below is the input data
the purpose of the cleansing is to have a zero instead of [Null]
and below is the output - no data
thank you
I know it is really strange and I can not see from where the problem come from!!
Do you have any other tool used in between Input and cleaning?
no I do not have
Hi @JMLAGIER
The Cleansing Tool doesn't delete rows or columns, unless you have Remove null rows or Remove null columns checked, which you don't according to your screen shots
The only other possible scenario where you can have data in the input and not in the output is the very specific case where you've just dropped a tool on the canvas and configured it but haven't run the workflow yet.
If this persists after a restart of Alteryx, I'd open a case at https://community.alteryx.com/t5/forums/postpage/board-id/@support
Dan