I'm trying to figure out how I can create two name fields in my output
mapping...
when both name fields basically have the same thing, except 1 value
I don't keep that information in the input schema, because most of it is
fairly constant....
The output has to look something like this

First name section
BT
Company name
15
San Number
Second name section
SP
Company name
15
San Number

I can't use string functoids to just load them up as constancts....
Because the BT has to come first.
I've tried doing a couple of things with the Table Looping functoid
and the value extractor, but am having problems getting that to work
Has anyone done something similar?
I really don't want to have to go to the trouble to add these constant
fields to the input schema
Most of the information on functoids lack a lot of detailed descriptions
with some kind of example.  I could use some ideas

[ Post a follow-up to this message ]

Is there two Company Names on the input?
If so then you can use a value mapping(flattening) functoid preceded by an
equals functoid.
Eric
http://stottcreations.com/blog

"Scot S" <ScotS@discussions.microsoft.com> wrote in message
news:7379ADE2-5469-401B-ACB8-F290208DAD78@microsoft.com...
> I'm trying to figure out how I can create two name fields in my output
> mapping...
> when both name fields basically have the same thing, except 1 value
> I don't keep that information in the input schema, because most of it is
> fairly constant....
> The output has to look something like this
>
> First name section
>     BT
>     Company name
>     15
>     San Number
> Second name section
>    SP
>    Company name
>    15
>    San Number
>
> I can't use string functoids to just load them up as constancts....
> Because the BT has to come first.
> I've tried doing a couple of things with the Table Looping functoid
> and the value extractor, but am having problems getting that to work
> Has anyone done something similar?
> I really don't want to have to go to the trouble to add these constant
> fields to the input schema
> Most of the information on functoids lack a lot of detailed descriptions
> with some kind of example.  I could use some ideas

[ Post a follow-up to this message ]

Actually, what I've shown is supposed to be the output.
I didn't use anything in the input schema, because I thought
that the output would be all constant values..
So basically, I'm trying to produce this output with constants..
because they will never change

"Eric Stott" wrote:

> Is there two Company Names on the input?
> If so then you can use a value mapping(flattening) functoid preceded by an
> equals functoid.
> Eric
> http://stottcreations.com/blog
>
> "Scot S" <ScotS@discussions.microsoft.com> wrote in message
> news:7379ADE2-5469-401B-ACB8-F290208DAD78@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

If there is nothing from the inpu driving the output, the easiest solution I
can think of right now is to redesign your output schema to have to seperate
records, and then in the map, in each of the properties of the elements,
code your two hard coded company information.
"Scot S" <ScotS@discussions.microsoft.com> wrote in message
news:925076E8-05CA-4430-BD72-A76B73927AF6@microsoft.com...[vbcol=seagreen]
> Actually, what I've shown is supposed to be the output.
> I didn't use anything in the input schema, because I thought
> that the output would be all constant values..
> So basically, I'm trying to produce this output with constants..
> because they will never change
>
> "Eric Stott" wrote:
> 

[ Post a follow-up to this message ]

Alternatively use the Scripting functoid with InLine XSLT including the
ouput Xml
e.g.
<namesection><code>BT</code><name>Company
name</name><number>15</number><San>San Number</San></namesection>
<namesection><code>SP</code><name>Company
name</name><number>15</number><San>San Number</San></namesection>

Greg

First name section 

"Eric Stott" <eric@stottcreations_nospam.com> wrote in message
news:eiKXQnXXGHA.4144@TK2MSFTNGP04.phx.gbl...[vbcol=seagreen]
> If there is nothing from the inpu driving the output, the easiest solution
> I can think of right now is to redesign your output schema to have to
> seperate records, and then in the map, in each of the properties of the
> elements, code your two hard coded company information.
> "Scot S" <ScotS@discussions.microsoft.com> wrote in message
> news:925076E8-05CA-4430-BD72-A76B73927AF6@microsoft.com... 
>
>

[ Post a follow-up to this message ]