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.

Invoice,Field1,Field2,Field3

A,12,12,12

A,13,13,13

A,14,14,14

B,11,11,11

B,21,21,21

C,13,13,13

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....

Regards,

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'



    Regards,

    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.

    Rgds

    Eng Swee

    Add comment
    10|10000 characters needed characters exceeded