Bug/local error? Creating null values for no raeson.

[Hamder83]

Hi 

I'm doing a simple workflow and I have 76734 records all filled out with a reciever country:

If I add a filter removing null values, it sorts out 14.307 records.

What am I missing?

[pedrodrfaria]

Hi @Hamder83 

Is it possible to share the dataset or at least a sample data?

What I have seen before was that the Browse was giving me false information and I actually had null values.

Pedro.

[Hamder83]

Hi 

Ive attached a copy of my workflow.

But if I set a filter as the first thing in the flow removing null values in reciever country - there is no null values.


I've created a field: FlowMapping which is ProductNamePurchase and DeliveryCountry

And this contains xxxxDK/UK and so on, so the row has a reciever country?

[Qiu]

@Hamder83 
It is indeed odd.

Perhaps you can provide a snapshot of the data coming out from T anchor of the Filter?

[pedrodrfaria]

Hi @Hamder83 

You have a column called ReceiverCountry (no null values) and a column called RecieverCountry (has null values).

When I fixed the filter tool to filter by the ReceiverCountry column, it worked perfectly, see below. Before the RecieverCountry was the one being used, which I'm assuming it was not the intention due to your questions.

[Qiu]

@Hamder83 

The filter is set for InvoiceNumberPurchase