Mapping Problem

[former_member185881]

Hi All

*
My source structure is:*                            *My Target Structure:*
MT_SND......                                                 MT_RCV.....
  row                                                              DATA
    Bill_No                                                          Bill
                                                                          Bill_No

My input is:

A1

A1

B2

I want output as:

Bill
   A1
Bill
   B2

I want to generate Bill as many times row is coming but for different values, If common values are coming then I dont want to generate Bill for that

Please help how to achieve this

Regards

Dheeraj Kumar

[rajasekhar_reddy14 · Accepted solution]

here you go

BillNo->SplitByValue(VaueChange)>collapseContext-->Bill

BillNo->removeContext->splitbyVallue(valuechange)--->BillNo

Regards,

Raj

[Former Member]

Hi,

a very fast solution is:

Bill_No (context to MT_SND) -> SplitByValue (Value Change) -> CollapseContexts-> Bill

Bill_No (context to MT_SND) -> SplitByValue(Value Change) -> CollapseContexts-> SplitByValue(Each Value)-> Bill_No

Be careful as I have altered the contexts in both nodes.

Edited by: Konrad Thalheim on Jul 1, 2011 5:46 PM

Edited by: Konrad Thalheim on Jul 1, 2011 5:46 PM

[rajasekhar_reddy14]

he its very simple.

use split by value (value change) it will work

Map billno>splitby value(value change)> Bill

billno-->billno

Regards,

Raj

[former_member185881]

Hi Raja

I did the same thing.

But in output i am getting

A1

A1

Dont know why B2 is not coming

my output should be

A1

B2

[Former Member]

Have you considered the contexts? In right click on the field Bill_No and set the context one level higher.

[Former Member]

You can find a good example for your problem here

[http://help.sap.com/saphelp_nwpi711/helpdata/en/42/f7293b2dbe1a71e10000000a422035/content.htm]