|
Home > Archive > BizTalk Server Orchestration > August 2005 > Mapping Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| millbrooktiger 2005-07-28, 5:52 pm |
| I want to map from following structure(extremely simplified version of the
xml):
<ROOT>
<INSERT>
<HEADERFIELDS>
<TABLENAME>tblLoan</TABLENAME>
</HEADERFIELDS>
<DATAFIELDS>
<DECISION>Approved</DECISION>
<LOANAMOUNT>10000</LOANAMOUNT>
</DATAFIELDS>
</INSERT>
<INSERT>
<HEADERFIELDS>
<TABLENAME>tblLoan2</TABLENAME>
</HEADERFIELDS>
<DATAFIELDS>
<DECISION/>
<LOANAMOUNT>20000</LOANAMOUNT>
</DATAFIELDS>
</INSERT>
</ROOT>
to the following structure:
<SESSIONXML>
<SESSIONDATE/>
<SESSIONTIME/>
<APPLICATION>
<DECISION/>
<LOANAMOUNT/>
</APPLICATION>
</SESSIONXML>
I want to map the decision from the tblLoan table and not the tblLoan2 table.
I want to map the LoanAmount (just for an example...not real world example)
from the tblLoan2 table and not the tblLoan table.
Help please.
| |
| Jason Agostoni 2005-07-30, 5:49 pm |
| What is the criteria you are using to decide when to use the DECISION
and LOANAMOUNT elements? For example, will there always be two and if
so will you always use DECISION from the first and LOANAMOUNT from the
second?
Or, will you always use the first DECISION and the highest LOANAMOUNT?
It's tough to give you ideas without knowing what are the triggers for
picking one value over the other.
Jason Agostoni
..Net Architect
CEI (www.ceiamerica.com)
http://jason.agostoni.net
| |
| millbrooktiger 2005-08-01, 8:09 am |
| My criteria is if the table name is tblLoan, then use decision from that
<INSERT> node/record. If the table name is tblLoan2, then use loanAmount
from that <INSERT> node. There is no set order and same table name records
could occur multiple times, even though not in this example. I didn't
include the multiple occurance nodes. I figured it was confusing enough.
|
|
|
|
|