Data360 Analyze

 View Only

  • 1.  Customizing Filter Node

    Employee
    Posted 12-13-2019 02:58

    Suppose I have a file named "ABC_12345678" where 12345678 is the product number.

    In an Excel file, I have a list of products with different product numbers.

    In Filter Node, I specify the Field = Product Number, Type = unicode, Operator = equals, when approaching the value part, I can't input customized field. So, I need to hard code 12345678.

    What I want to do is : Grab the product number from the file information ( I have done this part), however, how can I use it as input for filtering ?

    Many Thanks.

     

     

     



  • 2.  RE: Customizing Filter Node

    Employee
    Posted 12-13-2019 08:19

    You may want to use one of the correlation nodes such as the Lookup node or Merge node to select records where the product number matches the reference value(s)



  • 3.  RE: Customizing Filter Node

    Employee
    Posted 12-16-2019 00:05

    Thank you for your help, I have used merge to find the matched records:)