|
Home > Archive > BizTalk Server General > February 2005 > Biztalk Rules or Mapping - How to compare two lines of data from a message?
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]
| Author |
Biztalk Rules or Mapping - How to compare two lines of data from a message?
|
|
|
| Hi and thanks for any help in advance.
I have an interesting problem and I am hoping that Biztalk can solve
it, as it does most of what we need fine.
We process thousands of lines of data from flat files in batch. Each
line maps into a xsd format and we do some transforms etc and then act
on the xml using some rules. Works great.
One of our business problems relates to multiple lines from the flat
files. For example;
Lets say that in line #10 condition A is true and in line #35 condition
B is true, that combination of conditions should result in an certain
action, line #35 should be deleted and #10 should be updated to reflect
new values which need to be read from line #35.
I have pretty much given up on using rules only as a basis to solve
this. What I am thinking, is that it is going to take some clever
mapping using functoids to prep the xml message and then act on it
using a class or rules.
Has anyone out there had to do something similiar?
Thanks for any help or suggestions.
| |
| Alexander West 2005-02-10, 8:47 pm |
| Sounds like some inline XSL in a custom scripting functoid might do the
trick?
Alex
"Zack" <zack_shone@hotmail.com> wrote in message
news:1108061030.200721.177430@o13g2000cwo.googlegroups.com...
> Hi and thanks for any help in advance.
>
> I have an interesting problem and I am hoping that Biztalk can solve
> it, as it does most of what we need fine.
>
> We process thousands of lines of data from flat files in batch. Each
> line maps into a xsd format and we do some transforms etc and then act
> on the xml using some rules. Works great.
>
> One of our business problems relates to multiple lines from the flat
> files. For example;
>
> Lets say that in line #10 condition A is true and in line #35 condition
> B is true, that combination of conditions should result in an certain
> action, line #35 should be deleted and #10 should be updated to reflect
> new values which need to be read from line #35.
>
> I have pretty much given up on using rules only as a basis to solve
> this. What I am thinking, is that it is going to take some clever
> mapping using functoids to prep the xml message and then act on it
> using a class or rules.
>
> Has anyone out there had to do something similiar?
>
> Thanks for any help or suggestions.
>
|
|
|
|
|