cancel
Showing results for 
Search instead for 
Did you mean: 

how to genreate the idoc based on unique filed value

Former Member
0 Kudos

Hi experts,

Xml files contains multiple sales orders where each sales order can contains 1 to many items and in turn each item contains 1 to many characteristics and should be mapped to idoc

my question is number of idoc's to be generated depends on number of unique file filed value and no of items i.e E!EPO1 depends on unique ESTERNO filed for a sales order

Accepted Solutions (1)

Accepted Solutions (1)

PriyankaAnagani
Active Contributor
0 Kudos

Hi Chandra,

>>number of idoc's to be generated depends on number of unique file filed value ...

this can be achieved easily using graphical mapping.

file filed removecontextsortsplitByValueChangecollapsecontext-idoc

please post your source and expected target structures so that I can help you further

Thanks,

Priyanka

Former Member
0 Kudos

Hi Priyanka,

Thanks for the reply and also give me solution for that.

my question is but the xml file contains multiple sales order which are not sorted for that i need to sort and then i need to do that one

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>my question is but the xml file contains multiple sales order which are not sorted for that i need to sort and then i need to do that one

The previous reply says clearly for the requirement. FIrst use Removecontext function to remove all the contexts , then use SORT function to sort the fields, then use Splitbyvalue(value change) for each field value change then Collapsecontext to add it to appropriate node on the target side.

Answers (0)