Hi,
Is there any way to convert a empty field to Null?
Hi @Mina2021,
I'd use a similar approach to @Qiu, however if you only want to affect certain columns you can utilize the [_CurrentFieldName_] field available in the multi-field formula tool.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Kind regards,
Jonathan
If those columns are string you can use data cleansing tool in order to achieve it.
@Mina2021
We can try with Multiple Fields Tool
Hi Qiu,
Kindly refer below -
I was trying to multi field tool itself. But it's not working.
It works for me. Thanks.
