Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 54
	Members: 0
	Total: 54

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

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 Poster

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?

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

New Poster

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

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.