Skip to Content
0
Former Member
Mar 24, 2009 at 08:10 AM

Logic required to trasfer the data from .CSV file to Custom table table .

19 Views

Hi Experts ,

I urgently require a logic to transfer the data from the flat file which is of .CSV file into the Z custom table. The flat file contains list of Materials and its 5 Attributes . The scenario as follows :

1) If the flat file contains data such as 152124845,A,IN,GT,ST,FW (Material and its 5 attributes separated by comma)

Result expected : Needs to updated in the table as new record .

2) If the flat file contains data such as 152124845,B,,,,, (To modify certain material's attributes in DB table )

Result expected : Only the first attribute of the existing material has to be modified and rest of the attributed should remain the same.

3) If the flat file contains data such as 152124845,B,DELETE,,,, (To delete a particular attribute of existing material in DB table )

Result expected : Only the second attribute of the existing material has to be deleted and rest of the attributes should remain the same.

Kindly suggest to build a logic for the above scenario.

Thanks,

Kumaran