I want to map multiple attributes to one using the Schemamapper:
Ie:
InputFeature:
FirstName: Roger
Lastname: More
OutputFeature:
FullName: Roger More
How should the SchemaMapper.csv look like?
FullName, FirstName + LastName ???
Question
Schemamapper - multiple attributes to one
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.
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.
+22- Contributor
Hi,
I always have to refer to http://fmepedia.safe.com/articles/Samples_and_Demos/Mapping-Schemas-using-SchemaMapper when using the SchemaMapper. Maybe, you can find your case in one of these examples?
best regards,
Jelle
+25- Supporter
Hi! Thanks for the reply - however as far as I can see none of those cases describe my case.
I want to "merge" two input-attributes (Firsname AND Lastname) to a new attribute (FullName)
Hi Sig,
In my testing, Tcl "concat" command worked well. @Evaluate([concat @Value(FirstName) @Value(LastName)]),FullName I'm not familiar with Tcl, cannot describe more details... By the way, why not use the StringConcatenator or the AttributeCreator?
Takashi
+25- Supporter
Hi Takashi!
I am aware how to do it within FME - however the reason the SchemaMapper exist is to separate the mapping from FME itself (ie let a domain-expert do the mapping in EXCEL and the FME-expert take care of the rest:)).
+25- Supporter
Another option I tried was to do the following in the CSV:
InputAttribute OutputAttribute Firstname FullName @Value(FullName) @Value(LastName)' FullName
However that did not seem to work either - as the last value overwrote the Firstname
Tcl "format" command also worked fine. It might be more flexible than "concat" command. @Evaluate([format "%s %s" @Value(FirstName) @Value(LastName)]) I agree with you. There could be such a situation - dividing roles by domain-expert and FME-expert.
+25- Supporter
Ah,great - now it works with both options! Just had to put the formula in "DEFAULTVALUE" - column and not InputAttribute. Thank you
I learned Tcl a little more. This expression also worked, for what it's worth.
@Evaluate([return "@Value(FirstName) @Value(LastName)"])
I've never used Tcl so far, but it seems to have big availability especially for string processing.
P.S. These are better if FirstName or LastName may contain a special character (" [ ] <white space> etc.).
-----
@Evaluate([return {@Value(FirstName) @Value(LastName)}]) @Evaluate([format "%s %s" {@Value(FirstName)} {@Value(LastName)}]) @Evaluate([concat {@Value(FirstName)} {@Value(LastName)}])
-----