Skip to Content
avatar image
Former Member

Content Conversion in receiver channel

Hi All,

I have proxy to File scenario, I am receiving data in PI7.1 using proxy communication, and creating a CSV file at FTP location. There is no message mapping involved and there are 50 columns in my input data type, I have kept all the columns as optional.

When I receive the data from proxy, in first row I receive all the header names, so in first row, I receive all 50 column values. Suppose in second row, the value does not exist in ECC table for 5th column, so I receive only 49 column values in my 2nd row ( I donu2019t receive receive start and end tag with empty value for fifth column).

Thatu2019s why in my ouput csv, all the data values after 6th column onwards shifts to left by one place, as there is no value present for 5th column even not an empty value.

Please help me on this how can PI insert that empty value where it finds a missing column.

Thanks,

Ruchi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 25, 2011 at 12:01 PM

    Hi Ruchi,

    In your case, you need to hardcode some default values in proxy to make sure to get data.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2011 at 11:53 AM

    If you have mapping program then you can map MapWith defualt to achive this kind of req, but in your case you have to add some default value in Proxy it self,in PI not posibble.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2011 at 11:57 AM

    Hi Ruchi,

    For this you need to create a simple one to one Mapping.

    And you need to map your 5th field based on condition.

    Sourcefield--Count()=50--


    then map fifth field from source to fifth field of target.

    else if count<50 meqans 49 then map source 5th field to target 6th field and in 5th field map a blank constant

    if this value does not exist in ECC table can be for any column position then you need to add it in ECC proxy itself ........there is no way to handle it in PI.

    If it fixed like 5th position then you can use the logic mentioned by me.

    Add comment
    10|10000 characters needed characters exceeded