Skip to main content
Solved

combine two tables

  • September 26, 2019
  • 7 replies
  • 211 views

Forum|alt.badge.img

Hi , I want to combine two tables into one . Someone can help me ?

Best answer by david_r

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.

View original
Did this help you find an answer to your question?

7 replies

itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • September 26, 2019

Hi @mika,

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


Forum|alt.badge.img
  • Author
  • September 26, 2019
itay wrote:

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.

 

Thanks for your help

david_r
Celebrity
  • Best Answer
  • September 26, 2019

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.


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • September 26, 2019
david_r wrote:

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!


Forum|alt.badge.img
  • Author
  • September 26, 2019
david_r wrote:

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.

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


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 26, 2019

@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.


david_r
Celebrity
  • September 26, 2019
gio wrote:

@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?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings