Flat file load

[Former Member]

Hi,

I have one flatfile (CSV) which is having 45,000 records. my client ask me to load first 900 records. How i have to load first 900 records, with my existing InfoPackage.

Thanks in advance.

Regards,

Silpa

[Former Member · Accepted solution]

Hi,

Write a simple start routine at transfer rules use a logic which brings only 1 to 900 records ignore remaining records..

or

create new infopack and save 1 to 900 records in seperate CSV file and triger infopack

thanks

[Former Member]

Hi Silpa,

If you are getting data from other databases I mean R/3 or oracle then only we can able to select the data for loading ...that means in Infopackage level you have one option that is DATA SELECTION....

but you said that you are loading from CSV you dont have to option to load this many records from flatfile..

Through Routines you can solve ur problemm. otherwise if you are using BI 7.0 means fisrt you load ur data upto PSA after that in DTP extraction tab click on Filter option is there .. you can load based on ur selection from PSA..

thanks

@jay

AJAY KUMAR . N

[Former Member]

Thank for suggestions.

Temporary solution I copied first 900 records into new file.

Regards,

Silpa

[Former Member]

Hi shilpa,

Try in the update rule start routine

Data : lt_Data_pack like data_package occurs 0.

lt_Data_pack = data_package.
clear data_package. Refresh Data_package.
append lines of lt_Data_pack from 1 to 900 to Data_package.

Hope that Helps.

Regards

Mr Kapadia

[Former Member]

Hi Silpa,

Create a new file and copy the first 900 lines from the existing file to the new file.

Use it for loading.

Otherwise if you have any counter in this flatfile which you can use to determine the first 900 lines, you can use it in the infopackage to restrict it.

Regards.