Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: In list

  1. #1

    Default In list

    Hello,

    I have an excel file with a set of code. I want to know which codes are in a table of a SQL Server Database.

    I currently use the merge join step and I flag those fields that return a null value. I would like to know if there is another way to do this.

    Thanks.

  2. #2

    Default

    You could also insert you excel's set code on a temporary SQL server table and then execute a SQL statement where field in (.....)

    Hugo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.