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

Query Node Select Distinct Code, ProcessFlow Query

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
JudeBac
Veteran Member Send Private Message
Posts: 129
Veteran Member
11/6/2008 11:16 AM

 <!-- THE POST 3517855 -->
Hi all,

Processflow query node. I usually start and build the code in ProcessFlow String Wizard. I need to do a "select distinct EMPLOYEE from lawson.BNBEN".

This is my code so far:
PROD=&FILE=BNBEN&FIELD=EMPLOYEE&OUT=CSV&DELIM=~

ProcessFlow8.03 Pro

Kinda busy day for me. Thanks for the help.

Jude
John Henley
Send Private Message
Posts: 3351
11/6/2008 12:38 PM
Re: Query Node Select Distinct Code, ProcessFlow Query (ad8473ad-35be-4b13-ac2c-9273aedd1675) <!-- Converted from text/plain format -->

DME does not have a "distinct" qualifier. To achieve that, you would need to create a variable to compare against and use a branch to skip non-distinct/duplicate rows.

Thanks for using the LawsonGuru.com forums!
John
JudeBac
Veteran Member Send Private Message
Posts: 129
Veteran Member
11/6/2008 2:39 PM
My plan was to query EMPLOYEE then query BNBEN. Will proceed then. As always, thank you.
TommyT
Veteran Member Send Private Message
Posts: 58
Veteran Member
7/13/2010 12:45 PM
Can you go into a bit more detail on using the Employee file to help in achieving a distinct result in a query of employees elsewhere in the system?