Avoiding duplicates in parent scope when mapping field in Biztalk Map2019 Community Moderator ElectionHow to set a default value to an destination schema element in BizTalk MapProblem with BizTalk multi-input mapHelp required with BizTalk mappingCan't suppress nodes in BizTalk mappingBiztalk mapping, creating string[] from stringBizTalk Mapper Check and Replace Default ValuesBiztalk Map create duplicate target nodeBizTalk Map Group Person by KeyBizTalk Mapping:Source record does not exists but need to map and pass default valueValue mapping functoids into table looping functoid when not returning data
What is "desert glass" and what does it do to the PCs?
Create chunks from an array
How spaceships determine each other's mass in space?
Under what conditions would I NOT add my Proficiency Bonus to a Spell Attack Roll (or Saving Throw DC)?
How do we objectively assess if a dialogue sounds unnatural or cringy?
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Quitting employee has privileged access to critical information
What does "rhumatis" mean?
Deal the cards to the players
Short story about an infectious indestructible metal bar?
Remove object from array based on array of some property of that object
I can't die. Who am I?
Why won't the strings command stop?
When to use the term transposed instead of modulation?
Integrating function with /; in its definition
Is there a math equivalent to the conditional ternary operator?
Can inspiration allow the Rogue to make a Sneak Attack?
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
In the world of The Matrix, what is "popping"?
What does it mean when I add a new variable to my linear model and the R^2 stays the same?
Replacing tantalum capacitor with ceramic capacitor for Op Amps
Paper published similar to PhD thesis
Has a sovereign Communist government ever run, and conceded loss, on a fair election?
Are there other characters in the Star Wars universe who had damaged bodies and needed to wear an outfit like Darth Vader?
Avoiding duplicates in parent scope when mapping field in Biztalk Map
2019 Community Moderator ElectionHow to set a default value to an destination schema element in BizTalk MapProblem with BizTalk multi-input mapHelp required with BizTalk mappingCan't suppress nodes in BizTalk mappingBiztalk mapping, creating string[] from stringBizTalk Mapper Check and Replace Default ValuesBiztalk Map create duplicate target nodeBizTalk Map Group Person by KeyBizTalk Mapping:Source record does not exists but need to map and pass default valueValue mapping functoids into table looping functoid when not returning data
My situation is like this:
A "Code" field from the source tree, needs to be mapped to a "Code" field in the destination tree. The "Code" field in the destination tree has 2 parent nodes. For the destination schema to validate, the same code must not occur more than once in the scope of the 2nd parent node. Here's an image of the hiearchy:
So within the scope of "PurchaseInformation", no same "Code" may occur. A looping functoid loops on "GoodsDescription". I've tried to create an inline C# script to handle it, but it doesn't take the scope into account. See code below:
public System.Collections.Generic.List<string> duplicateList = new System.Collections.Generic.List<string>();
public bool IsDuplicate(string code)
if( duplicateList.Contains(code))
return false;
else
duplicateList.Add(code);
return true;
My problem is the global List that is created. It does not reset after each loop, but I'm unsure how to implement this functionality. My question is how I can make sure no duplicate codes are mapped within the scope of the "PurchaseInformation" record in the destination tree?
c# xml xslt schema biztalk
asked yesterday
LethLeth
461617
add a comment |
My situation is like this:
A "Code" field from the source tree, needs to be mapped to a "Code" field in the destination tree. The "Code" field in the destination tree has 2 parent nodes. For the destination schema to validate, the same code must not occur more than once in the scope of the 2nd parent node. Here's an image of the hiearchy:
So within the scope of "PurchaseInformation", no same "Code" may occur. A looping functoid loops on "GoodsDescription". I've tried to create an inline C# script to handle it, but it doesn't take the scope into account. See code below:
public System.Collections.Generic.List<string> duplicateList = new System.Collections.Generic.List<string>();
public bool IsDuplicate(string code)
if( duplicateList.Contains(code))
return false;
else
duplicateList.Add(code);
return true;
My problem is the global List that is created. It does not reset after each loop, but I'm unsure how to implement this functionality. My question is how I can make sure no duplicate codes are mapped within the scope of the "PurchaseInformation" record in the destination tree?
c# xml xslt schema biztalk
asked yesterday
LethLeth
461617
1
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago
add a comment |
My situation is like this:
A "Code" field from the source tree, needs to be mapped to a "Code" field in the destination tree. The "Code" field in the destination tree has 2 parent nodes. For the destination schema to validate, the same code must not occur more than once in the scope of the 2nd parent node. Here's an image of the hiearchy:
So within the scope of "PurchaseInformation", no same "Code" may occur. A looping functoid loops on "GoodsDescription". I've tried to create an inline C# script to handle it, but it doesn't take the scope into account. See code below:
public System.Collections.Generic.List<string> duplicateList = new System.Collections.Generic.List<string>();
public bool IsDuplicate(string code)
if( duplicateList.Contains(code))
return false;
else
duplicateList.Add(code);
return true;
My problem is the global List that is created. It does not reset after each loop, but I'm unsure how to implement this functionality. My question is how I can make sure no duplicate codes are mapped within the scope of the "PurchaseInformation" record in the destination tree?
c# xml xslt schema biztalk
asked yesterday
LethLeth
461617
My situation is like this:
A "Code" field from the source tree, needs to be mapped to a "Code" field in the destination tree. The "Code" field in the destination tree has 2 parent nodes. For the destination schema to validate, the same code must not occur more than once in the scope of the 2nd parent node. Here's an image of the hiearchy:
So within the scope of "PurchaseInformation", no same "Code" may occur. A looping functoid loops on "GoodsDescription". I've tried to create an inline C# script to handle it, but it doesn't take the scope into account. See code below:
public System.Collections.Generic.List<string> duplicateList = new System.Collections.Generic.List<string>();
public bool IsDuplicate(string code)
if( duplicateList.Contains(code))
return false;
else
duplicateList.Add(code);
return true;
My problem is the global List that is created. It does not reset after each loop, but I'm unsure how to implement this functionality. My question is how I can make sure no duplicate codes are mapped within the scope of the "PurchaseInformation" record in the destination tree?
c# xml xslt schema biztalk
c# xml xslt schema biztalk
asked yesterday
LethLeth
461617
asked yesterday
LethLeth
461617
asked yesterday
LethLeth
461617
asked yesterday
LethLeth
461617
asked yesterday
LethLeth
461617
461617
1
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago
add a comment |
1
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago
1
1
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Without seeing the whole process, it's difficult to give what might be the best solution...but...
Instead of trying to reset the collection (there are reasons this is difficult) you might try a list of lists instead.
Presuming SimplifiedInvoice is an ID or something, you can use a Dictionary of Lists which will track lists of unique Code values per Invoice.
answered yesterday
Johns-305Johns-305
9,880721
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55023001%2favoiding-duplicates-in-parent-scope-when-mapping-field-in-biztalk-map%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Without seeing the whole process, it's difficult to give what might be the best solution...but...
Instead of trying to reset the collection (there are reasons this is difficult) you might try a list of lists instead.
Presuming SimplifiedInvoice is an ID or something, you can use a Dictionary of Lists which will track lists of unique Code values per Invoice.
answered yesterday
Johns-305Johns-305
9,880721
add a comment |
Without seeing the whole process, it's difficult to give what might be the best solution...but...
Instead of trying to reset the collection (there are reasons this is difficult) you might try a list of lists instead.
Presuming SimplifiedInvoice is an ID or something, you can use a Dictionary of Lists which will track lists of unique Code values per Invoice.
answered yesterday
Johns-305Johns-305
9,880721
add a comment |
Without seeing the whole process, it's difficult to give what might be the best solution...but...
Instead of trying to reset the collection (there are reasons this is difficult) you might try a list of lists instead.
Presuming SimplifiedInvoice is an ID or something, you can use a Dictionary of Lists which will track lists of unique Code values per Invoice.
answered yesterday
Johns-305Johns-305
9,880721
Without seeing the whole process, it's difficult to give what might be the best solution...but...
Instead of trying to reset the collection (there are reasons this is difficult) you might try a list of lists instead.
Presuming SimplifiedInvoice is an ID or something, you can use a Dictionary of Lists which will track lists of unique Code values per Invoice.
answered yesterday
Johns-305Johns-305
9,880721
answered yesterday
Johns-305Johns-305
9,880721
answered yesterday
Johns-305Johns-305
9,880721
answered yesterday
Johns-305Johns-305
9,880721
9,880721
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55023001%2favoiding-duplicates-in-parent-scope-when-mapping-field-in-biztalk-map%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Does the PurchaseInformation have a unique item, e.g ReferenceNumber? Then concatenate ReferenceNumber and Code as input to your IsDuplicate function
– Dijkgraaf
yesterday
The PurchaseInformation field is located in the destination schema. Sorry if I did not make that clear in my post. Though the field in the input schema are very similar. I'll see if one of them is unique and use that to concatenate with code.
– Leth
19 hours ago