In the screenshot above there are no feature with both attributes _Anzahl_DT and _Anzahl_Privat present, which explains why the result is null.

If you need to do something about missing values, you can look into the NullAttributeMapper.

@tereziastredna

Expressions cannot be resolved when there are operands missing.

You need to first the row with the private address count (_Anzahl_Privat) merged tot he rest.

I glean from this picture that you have entered the total adres count and the adresse into the expression evaluator. This wil not relate them.

First use an unconditional Feature Merger (requestor key = supplier key, mostly we do 1=1).

Now you can execute the expression.

If you are not sure that all the operands are present, use a attribute creator in conditional mode and execute the expression in there. (I never use the expression evaluator because it misses a lot of functionality that the Attribute Creator has)

Condition would need to be "_Anzahl_DT has a value" AND "_Anzahl_Privat has a value"

Greets.

You could try using the adjacent features in the AttributeCreator transformer.

http://docs.safe.com/fme/2019.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/attributecreator.htm

Hello ,

I still did not find out how to delete the fileds in the table...

I ve tried "NullAttributeMapper" but there is no option to "delete" this rows only substitute them... I do not want to have them in the table. Would like to get something like this instead of this which I sent before...

NOT:

But all in 1 row

Thanks!

You can use an aggregator to get all the results on one row, ensuring that you use the option merge attributes. Presuming you have more than just the data above, you will need to have an attribute to group by, so the aggregator knows which rows of data to combine into one

Hi @egomm!

thanks a lot. It worked! So happy for it :-)