Skip to main content
Question

How to replace id by Values form another Table?

  • November 13, 2017
  • 1 reply
  • 14 views
M
Forum|alt.badge.img

Dear

takashi, I am facing a problem regarding inputting values in my metadata xml file from another table field. I have an element name <bnr:methods> in my xml and this element value is coming from a metadata table , for some column the value will be 'NULL' and for others it could be " 100, 101, 102..." together. This means a certain column method element has a list of values, but we want to see the real Method names as a list instead of ID list. for example " A, B, C.." where ID 100= A, 101=B, 102=C and this data is stored into another table name METHODE. I have prepared my xml root template expression but this is not working, can you please correct me! ?

Thanking you

With best regards

Muqit

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.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • November 15, 2017

Hi @mjoarder_pln, sorry the screenshot is too complex to understand correctly what your goal is. Can you post a simplified source dataset and desired XML document corresponding to the source?

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,090
Posts
121,869
Replies
39,731
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.