• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Parse USERMAP field in Process Flow

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Shaji
New Member
Posts: 3
New Member
New Poster
Engaged Reader
Avid Reader
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
Helpful Replier
New Poster
Engaged Poster
Avid Poster
Engaged Reader
Avid Reader
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.
Randy
Veteran Member
Posts: 50
Veteran Member
Helpful Replier
New Poster
Engaged Reader
Avid Reader
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.