Skip to Content
0
Former Member
Aug 03, 2016 at 07:30 AM

Sort and create node for IDoc, for blank values create individual IDoc

35 Views

Hi,

Below is scenario

AccNo Name1 Bank

100 John BANK1

101 Kelly BANK1

100 John BANK2

100 John BANK3

101 Kelly BANK2

---- Harry BANK3

---- Edd BANK2

Output:

IDoc : ZCREMAS05

In this case 4 IDocs should be created

IDoc 1:

E1LFA1M

100

John

E1LFBKM

BANK1

E1LFBKM

BANK2

E1LFBKM

BANK3

IDoc 2:

E1LFA1M

101

Kelly

E1LFBKM

BANK1

E1LFBKM

BANK2

IDoc 3:

E1LFA1M

----

Harry

E1LFBKM

BANK3

IDoc 3:

E1LFA1M

----

Edd

E1LFBKM

BANK2

I am using Sort+Split by Value change+Collapse context

But this will work only when AccNo has some value. Now, I need to create IDocs also when AccNo is blank in the file.

Please let me know if this can be handled by graphical mapping or we need UDF.

Thanks,

Vertika

Attachments