Skip to Content

How to do dynamic flat file split in sap bods ?

Example take EmpDetails table,having kind of records "EmpName, CityName" then split dynamically to different “txt” sheets as per the Common City Name ?

Ex .-

EmpName CityName

1 John Mumbai

2 Jay Delhi

3 Mathew Mumbai

4 Suresh Delhi

so how can i get all EMPName Having Same city as Mumbai in one .txt file and simillarly for EMPName Having Same city as Delhi in Another .txt file ?

Also how can i give path to store that new target .txt file to the my required destination folder in my local machine ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 13 at 04:43 PM

    use case transform and add condition on city column and take multiple targets for each output.

    Add comment
    10|10000 characters needed characters exceeded