-
1. Re: Convert the empty cells to NULL
Jim DehnerApr 9, 2018 5:38 AM (in response to Abaid Khalid)
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
Alvino Vaz Apr 9, 2018 5:51 AM (in response to Abaid Khalid)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
Abaid Khalid Apr 9, 2018 6:12 AM (in response to Alvino Vaz)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
-
4. Re: Convert the empty cells to NULL
Abaid Khalid Apr 9, 2018 6:12 AM (in response to Jim Dehner)I tried this and this result in column of undefined values.
-
5. Re: Convert the empty cells to NULL
Alvino Vaz Apr 9, 2018 6:19 AM (in response to Abaid Khalid)You can try and Group the Null and blank values to one as "Null"
Regards,
-AV
-
6. Re: Convert the empty cells to NULL
Abaid Khalid Apr 9, 2018 6:29 AM (in response to Alvino Vaz)I have grouped them, but I can't assign them Null.
Can you guide me please?
-
7. Re: Convert the empty cells to NULL
Alvino Vaz Apr 9, 2018 6:32 AM (in response to Abaid Khalid)Could you share a screenshot if possible or a sample file?