Question

How to replace id by Values form another Table?

  • 13 November 2017
  • 1 reply
  • 1 view

Badge

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

Userlevel 2
Badge +17

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?

Reply