Skip to Content

Determine output filename based on input filename content with RFC lookup

Hello Guys,

I have this sitaution which needs your ideas/sugestion.

1) PI system picks up text file from FTP server folders.

2) Within PI system, we need to dynamically determine output filename , logic to determine output filename will be :

2a) Read content of the input file particular line number (Fixed)

2b) Pass the value got from step 2a) to the Remote function module passing value read in step 2a) to get response

2c) Use response received from 2b) to construct output filename.

Please let me know if you have any qeustions on my problem, appreciate your ideas/suggestions.

Thanks,

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 22, 2011 at 09:44 AM

    Hi Nagendra,

    >>>>>Read content of the input file particular line number (Fixed)

    Let us say If you want to read some FieldA from line 5 , then read the 5th value from the input queue of FiledA...use CopyValueOf function to read the 5th value and pass it as input to RFClookup and get response and pass the response as input to UDF where you'll construct target filename & implement Dynamic configuration .

    Regards

    Priyanka

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Priyanka,

      You are right I am going to use File Content Conversion technique to read input TEXT file and then will use CopyValue function to read the specified row in the input file and then pass on to the RFCLookup function.

      Thanks & my appreciation for everyone who answered my question.

      Best Regards,

      Krishna

  • Sep 22, 2011 at 09:58 AM

    in your case, you will need to do a RFC lookup and based on the response do a dynamic configuration for the output file name.

    It will remain as the standard way of doing it with the only additional logic that you will have to do a RFC lookup and then proceed with the response of that to create the file name.

    ref: /people/shabarish.vijayakumar/blog/2009/03/26/dynamic-configuration-vs-variable-substitution--the-ultimate-battle-for-the-file-name

    Add comment
    10|10000 characters needed characters exceeded