Prev
Next
Forums IPA/ProcessFlow

Parse USERMAP field in Process Flow

Sort:
You are not authorized to post a reply.
Author
Messages
Shaji
New Member
Posts: 3
New Member
6/2/2014 6:36 PM
    I am extracting some data from the APINVOICE table for a vendor. In the APINVOICE table, there is a column called OPERATOR. I am trying to tie the OPERATOR to its name. I have the operator data in a text file that I am pulling into the process flow using File Access.

    How do I connect the OPERATOR to its name in process flow?

    1 NT00000009 RULSFDEV\TRN01 TRN01 1401048974
    I want to connect the NT0000009 from the APINVOICE table and pass the name instead of the ID.

    Any suggestions please.

    Thank you!
    Tags: Process Flow
    Robert Spurr
    Veteran Member
    Posts: 130
    Veteran Member
    6/6/2014 6:47 PM
      Use the Data Iterator to parse the record and pass the ID to the Resource Query to get the name. I would build the record with the file access node with a delimiter like '^' to make parsing easy.
      Tags: Process Flow
      Randy
      Veteran Member
      Posts: 50
      Veteran Member
      6/12/2014 2:48 PM
        I've created a process flow that dumps the listusermap to a file, reads and parses the file and inserts the data into a custom table in our production db. Updates the table from LTM with name and email adress so we have a working table to join for reporting of all users NT ID's.
        Tags: Process Flow
        You are not authorized to post a reply.