Skip to main content
Question

How to replace id by Values form another Table?

  • November 13, 2017
  • 1 reply
  • 10 views

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

1 reply

takashi
Evangelist
  • 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?


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