Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Multiple source files to one destination schema.. Looping functoid?

59 views
Skip to first unread message

Gavin Kelly

unread,
Jul 8, 2004, 11:55:32 AM7/8/04
to
Hi all

Created a new map with 2 source schemas combined to produce 1 destination
file. Both the source files have multiple rows but the destination file only
contains 1 row (the first entries of each of the source files).

Been investigating and playing around with the Looping functoid - but no
joy!

Has anyone got any ideas?

Thanks
Gavin


Christof [MVP] at dot

unread,
Jul 8, 2004, 12:28:25 PM7/8/04
to
A couple of custom inline XSLT lines could probably help you... (match a
template with xpath xpression that has predicate like "[1]")

Best regards,
Christof

--
Christof [Microsoft BizTalk Server MVP]

"Gavin Kelly" <Gavin...@cqsm.com> wrote in message
news:uf6lBQQZ...@TK2MSFTNGP09.phx.gbl...

Gavin Kelly

unread,
Jul 8, 2004, 12:32:36 PM7/8/04
to
Christof

Thanks for the reply but I havnt got a clue what your talking about - is
this whats generated when you link some fields to the looping functoid?

Lets says for example Im trying to merge these 2 files into 1

Source Specification File 1
---------------------------
Item Code
Item Name
Item Description

Source Specification File 2
----------------------------
Item Code
Transaction Time
Transaction Amount

Destination Specification File
--------------------------
Item Code
Item Name
Transaction Time
Transaction Amount

Should I link the Item Code from each source spec through a looping
functoid?


"Christof [MVP]" <bts2004communityfeedback (at) hotmail (dot) com> wrote in
message news:u5EtZgQZ...@TK2MSFTNGP09.phx.gbl...

Christof [MVP] at dot

unread,
Jul 8, 2004, 1:06:19 PM7/8/04
to
Use the advanced scripting functiod where you can insert custom XSLT script.

Best regards,
Christof

--
Christof [Microsoft BizTalk Server MVP]

"Gavin Kelly" <Gavin...@cqsm.com> wrote in message

news:e$PHvkQZE...@TK2MSFTNGP09.phx.gbl...

Tatyana Yakushev [MSFT]

unread,
Jul 8, 2004, 3:25:16 PM7/8/04
to
If you need to get value of first occurence of repeating field you can use scripting functoid.

May be in your case you don't need to use looping functoid. Looping functoid is used to create new element at the target schema for every occurence of element at the
source schema.

Can you give more complicated example when nodes repeat at the source document?

Thanks,
Tatyana

--------------------
>Reply-To: "Gavin Kelly" <Gavin...@cqsm.com>
>From: "Gavin Kelly" <Gavin...@cqsm.com>
>Subject: Multiple source files to one destination schema.. Looping functoid?
>Date: Thu, 8 Jul 2004 16:55:32 +0100
>Lines: 15
>Organization: CQSM
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
>Message-ID: <uf6lBQQZ...@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: 212.187.179.144
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:17019
>X-Tomcat-NG: microsoft.public.biztalk.general


--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.

Gavin Kelly

unread,
Jul 9, 2004, 6:02:38 AM7/9/04
to
Ok, I have 2 source xml files (schema1 and schema2) and 1 resulting
destination xml file (schema3)

schema1 :
<TestMessage xmlns="http://TestMessaging.Schema1">
<ID>0000001</ID>
<Message>Schema0000011</Message>
<ID>0000002</ID>
<Message>Schema0000012</Message>
<ID>0000003</ID>
<Message>Schema0000013</Message>
</TestMessage>

schema2 :
<TestMessage2 xmlns="http://TestMessaging.Schema2">
<ID>0000001</ID>
<Message>Schema0000021</Message>
<ID>0000002</ID>
<Message>Schema0000022</Message>
<ID>0000004</ID>
<Message>Schema0000024</Message>
</TestMessage2>

What Im after for schema3 is :
<TestMessage3 xmlns=http://TestMessaging.Schema3>
<ID>0000001</ID>
<Message1>Schema0000011</Message2>
<Message2>Schema0000021</Message2>
<ID>0000002</ID>
<Message1>Schema0000012</Message2>
<Message2>Schema0000022</Message2>
<ID>0000003</ID>
<Message1>Schema0000013</Message2>
<ID>0000004</ID>
<Message2>Schema0000024</Message2>
</TestMessage3>

Any clues?

"Tatyana Yakushev [MSFT]" <taty...@online.microsoft.com> wrote in message
news:776sPFSZ...@cpmsftngxa06.phx.gbl...

Tatyana Yakushev [MSFT]

unread,
Jul 9, 2004, 12:21:50 PM7/9/04
to
Just realized that you may want to have XML to try the map with (because it is a multi-part transformation).

Here it is.

Tatyana
--------------------
>Reply-To: "Gavin Kelly" <Gavin...@cqsm.com>
>From: "Gavin Kelly" <Gavin...@cqsm.com>

>References: <uf6lBQQZ...@TK2MSFTNGP09.phx.gbl> <776sPFSZ...@cpmsftngxa06.phx.gbl>
>Subject: Re: Multiple source files to one destination schema.. Looping functoid?
>Date: Fri, 9 Jul 2004 11:02:38 +0100
>Lines: 105


>Organization: CQSM
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409

>Message-ID: <#jhVevZZ...@TK2MSFTNGP11.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: 212.187.179.196
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXS01.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:17065
>X-Tomcat-NG: microsoft.public.biztalk.general

del.xml
0 new messages