Remove NULL Values from Data

[Olivia_Rose199711]

Hi Experts,

I have joined my two tables using left join. but after that i can see some null values have generated in that table. So how do I remover null values from that generated table. 

[ramasaisaksoft · Accepted solution]

1) "surpress when value is Null"

2) after Join condition use where clause like here

Where Len(Trim(Field)) > 0 ;

3) LOAD * from Table Where Not IsNull(Field);

if you still need please share your sample data with sample fileds

4)

[Final Table]:

Load * Resident Table where Len([Sales Order CSR]) <> Null()

Group By Sales Order CSR;

[Or · Accepted solution]

1) Left join means you keep the left side even if the right side is missing (in which case it will be null). Did you mean to use a regular (inner) join?

2) Nulls can exist regardless of the join in the data. 

3) You can add WHERE conditions such as Field1 IS NOT NULL to filter out lines where specific fields are null.