How to send one of the field value from .csv file to target field
We got a change request for one our interface. The scenario is File to IDOC. PI is receiving .CSV file from FTP which may contains multiple line ITEMS.But PI is creating one IDOC with single Header segment and multiple line item segments. Here as per the new requirement changes am sending File name to one of the target field in IDOC by using UDF code.
Now we received another request from client, like each line item in the .CSV file may contain one Company_code. So we need to send the file name to target field (at line item level) at run time, which I have achieved already by using UDF.
But here the requirement is, I need to capture the Company_code from each line item in the Text file and need to send this to one of the target field at ITEM level.
Below is my .CSV file contains 2 line Items
My file name is Orders*txt
So I need to capture the file name and should combined this with COMPANY1 like ----> OrdersCOMPANY1.txt which I need to transfer to one of the filed (Company_code) in the fisrt line item segment in the target IDOC
In the same for second line item ---> OrdersCOMPANY2.txt need to send to the Company_code field in to the second line ITEM.
So can any one please tell how I cam
Sreenivas Veldanda replied
for this u can get the filename by using the dynamic configuration ...
then concat the dynamic configuration output and the last field in the csv file and assgn to the target field.
You can assign the udf to one variable in the mapping.
CONCAT ----------------> TARGET FIELD.....
CSV File last field