IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  XML Mapping

    Posted 09/12/12 01:27 AM

    Originally posted by: ManojBansal


    Hi All,

    I am finding difficulty in mapping the below scenario. Any help is this regard will be great!

    Section - 1

    <itemFact conceptRef="pyde.02.00_OrganisationNameDetails.OrganisationalNameType.Code" id="fact_0">
    <stringValue>MN</stringValue>
    </itemFact>
    <itemFact conceptRef="pyde.02.00_OrganisationNameDetails.Currency.Code" id="fact_1">
    <stringValue>C</stringValue>
    </itemFact>
    <itemFact conceptRef="pyde.02.00_OrganisationNameDetails.OrganisationalName.Text" id="fact_2">
    <stringValue>Altova</stringValue>
    </itemFact>
    .....

    Section - 2

    <tupleFact conceptRef="orgname2.02.00_OrganisationNameDetails">
    <itemFact ref="fact_0"/>
    <itemFact ref="fact_1"/>
    <itemFact ref="fact_2"/>
    </tupleFact>
    .....
    both itemFact and tupleFact are coming at same level hierarchy.
    <ItemFacts>
    <itemFact>
    </itemfact>
    </ItemFacts>

    <TupleFacts>
    <tuplefact>
    </tuplefact>
    </TupleFacts>

    1) I need to first search for "OrganisationNameDetails" in "conceptRef" attribute of tupleFact.
    then i need its corresponding <itemfact> ref values, i.e "fact_0", "fact_1" and "fact_2".

    2) With the above "fact_0" value i need to search on section - 1 "itemFacts"
    if its id="fact_0", then search for its corresponding conceptref whether its contains "OrganisationNameDetails.OrganisationalNameType.Code" or not and whether its corresponding string value = "MN".

    3) if the above condition satisfy then map the string value of item facts whose conceptref contains "OrganisationalName.Text" which is "fact_2" in this.

    Now can someone please let me know how can i do this as I am just a beginner in WTX and also if you need more info to understand the problem.

    Regards
    Manoj
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: XML Mapping

    Posted 09/19/12 05:25 PM

    Originally posted by: repanzer1


    Rather then explaining what you think you need to do to achieve something, explain exactly what it is you want to achieve. This is for a map, right? What is your input, what is your output? What do you need from your input to populate what in your output? Something you said above does not make sense to me. I do not know where you got "contains "OrganisationalName.Text" which is "fact_2"".

    You first said (1) you need fact_1, fact_2, fact_3.

    Then you say (2) you want to use those values, and see if the itemFact which has that value in the ID ref, has MN as the string value and "OrganisationNameDetails.OrganisationalNameType.Code" in the conceptref or not. Well what if it does? What if it doesn't? I don't know what you're trying to do.


    There are 10 types of people in this world. Those who understand binary and those who don't.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange