Visual Query Builder using IN when connecting to excel file

cowannbell

Our database is very large, so I'm trying to filter as much data as possible in the Visual Query Builder.  I'm try to do this.  It is not accepting the file location.  Can I do this and if so, what am I doing wrong?

select GDAD00D.TBL_DAD_RATES_AUSH.SERVC_CD,
GDAD00D.TBL_DAD_RATES_AUSH.RATE_SYS_CD,
GDAD00D.TBL_DAD_RATES_AUSH.RATE,
GDAD00D.TBL_DAD_RATES_AUSH.EFFTV_DT,
GDAD00D.TBL_DAD_RATES_AUSH.SPCLTY,
GDAD00D.TBL_DAD_RATES_AUSH.SERVC_TYPE,
GDAD00D.TBL_DAD_RATES_AUSH.ERR_IND,
GDAD00D.TBL_DAD_RATES_AUSH.TRMN_DT
from TBL_DAD_RATES_AUSH
where GDAD00D.TBL_DAD_RATES_AUSH.RATE_SYS_CD IN (C:\data\DADs.txt)
and GDAD00D.TBL_DAD_RATES_AUSH.ERR_IND = 'N'
and GDAD00D.TBL_DAD_RATES_AUSH.TRMN_DT =
order by GDAD00D.TBL_DAD_RATES_AUSH.RATE_SYS_CD, GDAD00D.TBL_DAD_RATES_AUSH.SERVC_CD

mceleavey

Hi @cowannbell ,

this method will not work simply because you are trying to define a range, but instead are providing a filepath to an external source. This is not how you reference a secondary source and so it would never understand the syntax here.

You can copy the values on your text file and present them in the WHERE clause as follows:

Alternatively you can connect using the In DB tools, which will allow you to stream in the data from your external source and join to the In DB table. This will then allow you to use the Join In Db tool to reduce your data before streaming the results out into Alteryx:

I hope this helps.

M.