cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping issue

Former Member
0 Kudos

Hi,

how to do following please?

>Source

><body>

><val>1</val>

><val>2</val>

><val>2</val>

><val>3</val>

></body>

>and create

><body2>

><val2>1</val2>

><val2>2</val2>

><val2>3</val2>

></body2>

So I will create only one target node per unique val value from the source?

Thanks,

Olian

Accepted Solutions (1)

Accepted Solutions (1)

former_member192892
Active Contributor
0 Kudos

val--->SPlitbyValue(Value changed)>CollapseContext->target

regards

Varun

Answers (4)

Answers (4)

Former Member
0 Kudos

To add on to what Varun has suggested

val>sort>SplitByValue(value change)>collapse context> val2

sort is used in case you get input data like 1,2,3,3,2 ... not in

sort properties --> numerical,ascending

Former Member
0 Kudos

Varun's solution works. Thanks guys.

Olian

p.s. I have another mapping issue check my new thread please

markangelo_dihiansan
Active Contributor
0 Kudos

Hi Olian,

Based on your description, the source and target structure occurences should be set to 0..unbounded or 1..unbounded then you can use the mapping technique as described by Varun..

Regards,

Mark

Former Member
0 Kudos

Hi ,

I think you will have to write a UDF for this in which you can loop over the incoming values and just pass the unique ones by keeping a check.

Regards,

Manjusha.

Former Member
0 Kudos

Hi Olian,

are the values (1,2,3) fixe or variable (1,2,3...n)?

If they are variable you cannot use graphical mapping

Regards Mario