Select one value from mutiple values from source and put it in single target field?

[Former Member]

Dear All,

I have a problem in my hand.

My source structure is

And target structure is

Here I have to map LHC with CharValue only when charname = 'Logistics'. As multiple values are coming in source structure I am only getting first value from source. I tried using node functions but not able to crack it.

Can anybody help me in this?

Thanks.

SM.

[Harish · Accepted solution]

Hi Sumeet,

If you want all the values from source where charname = 'Logistics' then use the below logic

For Data (node)

charname map with default (blank) --> equals 'Logistics' then if without else map CharValuationChar --> Data

For LHC

charname map with default (blank) --> equals 'Logistics' then if without else map CharValue--> LHC

regards,

Harish

[Former Member · Accepted solution]

Thanks Hari and Harish for ur replies.

@Harish: I tried logic as

In LHC node value 50007500 shd come, but as first value is getting suppressed node LHS is not coming.

Any advice.

Thanks.

[Harish · Accepted solution]

Hi Sumeet,

check the property of if without else and remove the check box keep suppress.

regards,

Harish

[former_member190624 · Accepted solution]

Hi Sumeet,

After If condition , use SplitByValue and then LHC. Now , you should get your result .

Thanks

Hari.

[Former Member · Accepted solution]

Hi Sumeet

Use removeContext node function after the field 'CharName' and 'Charvalue' or set the context to at the hire level.

Then your map should work.

[Former Member · Accepted solution]

Hi Indrajit,

You logic is working.

@All: Thanks for ur replies and time. Points will be awarded.

[Former Member · Accepted solution]

Friends,

I am not able to see the link from where points can be awarded...Can anybody help me to locate the link?

Thanks.

Sumeet.

[Former Member · Accepted solution]

Hi Sumeet

When you open the post in SCN, on each comment you will see the option's

helpful answer, correct answer

Select the comment as correct answer which you think solve your problem.

Select the comment as helpful which you think was helpful.

That's it. Very simple and easy.

[former_member190624]

Hi Sumeet,

Try below logic,

CharValue  -> RemoveContext  ->  equals (CharValue == Logistics) -> CreateIf -> LHC

Also please provide screen shot of mapping logic you created along with display queues.

Note : Source will be CharValue  and target will be LHC.

Thanks

Hari.