Skip to main content
Solved

combine two tables

  • September 26, 2019
  • 7 replies
  • 244 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • 1442 replies
  • 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
  • 8 replies
  • 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)?

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
  • 8394 replies
  • 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+18
  • Supporter
  • 1442 replies
  • 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.

Nice one @david_r!


Forum|alt.badge.img
  • Author
  • 8 replies
  • 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.

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


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • 2252 replies
  • 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
  • 8394 replies
  • 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.

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