1 of 1 people found this helpful
There are a couple thins you could do (don't hold me to the syntax I don;t have your twbx workbook
if they are truly always the same you could use a case statement
When 1 then 10
When 2 then 50
When 3 then 30
When 4 then 30
A different approach would us a conditional if then type statement
if ID=1 and isnull(Number) then 10
elseif ID=4 and isnull(Number) then 30
else Number end
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.
thank you very much for your reply.
Unfortunately, the case is a bit more difficult. Instead of just the sample I provided, the whole dataset consists of more than thousand rows with more than 500 different ID’s. Therefore, the methods are not useful.
Also, I need to replace the null values of not just one column, but multiple columns with null values.
Do you have a solution? And can you provide a packaged workbook?
thank you in advance
we can only work with the information you tell us - if you had that many replacements you would have included it in the post and I would have told you to create a separate file with a was/now type replacement to join to you current data
and NO - we are here to help you solve you problem not to do it for you