-
1. Re: Convert the empty cells to NULL
Jim Dehner
Apr 9, 2018 5:38 AM
Good morning
have you tried
ifnull(lookup(min([column name]),0),Null)
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Convert the empty cells to NULL
Hi Abaid Khalid,
As you mention your column contains string values so you can use the Edit Alias option .
Below is an example for the same,Consider the category column has null values
In the above screenshot i have replaced the Furniture Value with Null .
Hope this solves your problem.
Regards,
-AV
-
3. Re: Convert the empty cells to NULL
When I try to change the aliases, it produces the following error.
Cannot assign two members the same value (alias).
Null is already aliased as Null
-
-
5. Re: Convert the empty cells to NULL
You can try and Group the Null and blank values to one as "Null"
Regards,
-AV
-
6. Re: Convert the empty cells to NULL
I have grouped them, but I can't assign them Null.
Can you guide me please?
-
