Hi @mika,

I know this is an FME forum, but wont it be easier to do this in Excel ( assuming you are using Excel)?

yes i work with excel but I have to extracts data with transformers in fme and thats why I need help for this. I used featuremerged or joiner but its doesnt work. I tried to use attributecopier to recopie the data into new attributes. However, it keeps only one of them . I cant reach to get one table combined with all the datas.

If these are two columns in the same sheet, the simplest solution is probably to use the NullAttributeMapper,e.g.

This will make sure that the attribute "azimut recherché" gets the value from "A_azimut rechercé" if it's empty, null or missing.

Nice one @david_r!

it works well . I only changed one thing. thanks for your help

@mika

You could have used a attribute creator in conditional mode.

Then you would not have to overwrite data, which is what using the nullatrributemapper does in david's setup.

By overwriting data, you mean replacing the empty value with another value? Or am I missing something else?