Copy from Excel and paste into Query Builder

Question

Hello,

I want to perform a query on a list of values from an Excel Spreadsheet.  Using Query builder I would normally paste the value in "criteria" which will create many  ORs in the query. Is it possible to copy a column from Excel and paste into Query builder so I will not have to copy and paste each value separately?

Fitzteri · Answer

Thank you. I will take a look at this when I get a chance and let you know if this worked. Thanks for taking the time to respond.

Teri

AbhilashR · Answer

Hi @Fitzteri, assuming you are referring to the Criteria options under the Visual Query Builder view in the Input Tool, I don't think there is a copy-paste method that allows us to paste multiple values at one go.

Alternatively, if you have a pre-existing SQL and are looking to parametrize one of the WHERE clause by bringing it from Excel, then the solution provided by @JagdeeshN is a viable approach.

JagdeeshN · Answer

Hi @Fitzteri,

The following steps should get you to the solution:-

1. You can do that by using the Cross Tab  tool to create the column list string.

2. This string can then be used within a dynamic input tool, with the intent of replacing part of the query(column names) during runtime.

3. This list of columns is read from an excel file

Please find attached a workflow example.

Best,

Jagdeesh Narayanan

Solution1.yxzp