Solved: Database query with values from a table

Anonymous · ‎11-10-2021

Hi,

newbie question - I'm trying to fetch a set of ID's from a table and use it when loading data from our SQL database - no luck so far. The where clause should include a set of ID's selected from a table (where "Include" = true). Help would be greatly appreciated.

Anonymous · ‎11-11-2021

You've got to get the filter values into the same cell, like 123,456,457,897,etc.

You can first transpose and then merge (combine) the columns and use a comma for the delimiter. Drill down on the one field, and then refer to your variable in the SQL, which you do have written correctly.

--Nate

View solution in original post

Anonymous · ‎11-11-2021

Thanks!

Anonymous · ‎11-11-2021

You've got to get the filter values into the same cell, like 123,456,457,897,etc.

You can first transpose and then merge (combine) the columns and use a comma for the delimiter. Drill down on the one field, and then refer to your variable in the SQL, which you do have written correctly.

--Nate