Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello..
I have data in my LOAD statements, where one Employee have a value while another has not any records about it.
How can I convert null() values to 0
I have tried the LOAD statement bollow, but it doesn't help.. one employee still has "-" value instead of 0
Load
Employee,
IF(Coffee_Rent = null(),0, Coffee_Rent) AS Coffee_Rent
RESIDENT Another_Table.
I am not sure how to use it..
And the result is the same:
Thank you all guys!
I found my problem!
I used two parameters for Employees with the help of JOIN. As the result, for some Employees were not presented in the first LOAD statement.
For my needs I started with the full list of empoyees and then sed rangesum function.