Skip to Content

Key Field Value for File Adapter Sender Wildcard

Hi Experts,

My scenario is that i have a comma seperated .CSV file, converting it to xml format using the file content conversion (FCC).

The problem is the value of key field is not fixed,

Example: i have a key field Invoice and initially it's value is A, i got 3 records with the same key value and in the 4th record the value is changed to B.








So, in the result i require one Recordset for value 'A' and one for 'B' and similarly for other key values.

Can i put something in the keyFieldValue like a wildcard with the help of which PI can recognize the changed value and create a new Recordset.

This is a very urgent. Waiting for you replies....


Aayush Aggarwal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 08, 2015 at 07:09 AM

    Hi Aayush,

    My suggestion would be read each record as separate recordset and then in mapping using Node function Split by value - Value Changed, you can have the required recordset in single context.

    In FCC you can use this -

    Recordset Structure - Transaction,*

    Transaction.fieldNames - field1,field2,field3,field4

    Transaction.fieldSeparator - 'nl'


    Nitin Deshpande

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2015 at 06:52 AM

    Hi Aayush

    From your sample above, the lines all contain similar structure. If that is the case, you don't need to configure key field value as there is just 1 recordset structure. You can additional configure an offset to ignore the first line.


    Eng Swee

    Add comment
    10|10000 characters needed characters exceeded