Skip to Content
0

How to do dynamic flat file split in sap bods ?

Feb 13 at 09:01 AM

116

avatar image

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ravi kiran Pagidi Feb 13 at 04:43 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Thanks Ravi, can you please tell me how can i give the path of that target files to store it in my desired folder rather than the previous default folder.?

0

specify the path in the target file in the filepath tab.

1

Thanks ravi

0