AnsweredAssumed Answered

Spliting flat file

Question asked by shyam.mohan.upadhyay560527 on Jun 13, 2018

Hi All,

 

I have one flat file depicted below :

 

id|col1|col2|col3|col4
1|BUKRS|BLART|BLDAT|SGTXT
2|BSCHL|SHKZG|WRBTR|SGTXT
3|BSCHL|SHKZG|WRBTR|SGTXT
1|BUKRS|BLART|BLDAT|BUDAT
2|BUKRS|BLART|BLDAT|BUDAT
1|BUKRSD|BLART|BLDAT|SGTXT
2|BSCHLA|SHKZG|WRBTR|SGTXT
1|BUKRSDX|BLART|BLDAT|SGTXT
2|BSCHLAY|SHKZG|WRBTR|SGTXT
3|BSCHLUI|SHKZG|WRBTR|SGTXT

 

now I want to split this profile in 4 documents like below :

id|col1|col2|col3|col4
1|BUKRS|BLART|BLDAT|SGTXT
2|BSCHL|SHKZG|WRBTR|SGTXT
3|BSCHL|SHKZG|WRBTR|SGTXT

 

id|col1|col2|col3|col4

1|BUKRS|BLART|BLDAT|BUDAT
2|BUKRS|BLART|BLDAT|BUDAT

 

id|col1|col2|col3|col4

1|BUKRSD|BLART|BLDAT|SGTXT
2|BSCHLA|SHKZG|WRBTR|SGTXT

 

id|col1|col2|col3|col4

1|BUKRSDX|BLART|BLDAT|SGTXT
2|BSCHLAY|SHKZG|WRBTR|SGTXT
3|BSCHLUI|SHKZG|WRBTR|SGTXT

 

Please suggest how can I achieve it.

 

Thanks,

Shyam

Outcomes