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
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
    Posts: 3353
    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
      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
        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?