SOLVED
Replacing a null or 0 value with 1 in an column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sriniprad08
11 - Bolide
‎06-30-2021
04:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I need help.
i have a column with null and 0 and i need to replace both of them with 1.
can you please help?
thanks
Sri
Col1 |
NULL |
NULL |
0 |
0 |
3 |
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Expression
4 REPLIES 4
17 - Castor
‎06-30-2021
05:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-30-2021
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AlexandreBall
5 - Atom
‎06-30-2021
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎06-30-2021
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AlexandreBall,
Thank you for posting your solution.
I didn't know that you can write this condition as [Col1] = Null(). I always written IsNull([Col1]) 😀
