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