Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try with below
Load
tag_color
from....
where IsNum(tag_color );
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 ?
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.
I want both tables
One table where tag_color ='NULL'
and other table where tag_color <>'NULL'
How can i achieve it ?
Hi
Can you send the sample data & expected output to proceed further.