Remove null value keyword from data field

[Aspiring_Developer]

Hello everyone,

I have a below data column:-

I want to remove this 'NULL' key word , i tried below :-

Table:

Load

tag_color

from....

where tag_color <>'NULL'

It did not work , i am still able to see the NULL value in the data column.

Can anyone please help ?

[MayilVahanan]

Hi @Aspiring_Developer 

Try with below

Load

tag_color

from....

where IsNum(tag_color );

[Aspiring_Developer]

Hi @MayilVahanan 

When i apply the query like below:-

Data :

Load tag_color

from...

where tag_color <> 'NULL' and run the script, NULL is removed.

However, when i try to do the below :-

Data 

Load tag_color,

tga_uid..

tag_changedate

tag_trolleyid

..from ...

Temp:

tag_uid

max(tag_changedate) as Last_date_paint

resident Data

Where tag_color <> 'NULL'

group by tag_uid;

When i create table it does not work (tag_color ) show values for both (NULL and numbers)

IS it becuse both the tables have common key as tga_uid linking them ?

[MayilVahanan]

Hi @Aspiring_Developer 

Yes, its might be due to tag_id. 
If you don't want "NULL" value in ur app. You can apply where condition in initial load itself.

[Aspiring_Developer]

Hi @MayilVahanan 

I want both tables

One table where tag_color ='NULL'

and other table where tag_color <>'NULL'

How can i achieve it ?

[MayilVahanan]

Hi

Can you send the sample data & expected output to proceed further.