Need Help in Script Where condition

[#1]

Hi,

I would like to load only list of numbers from the database, so I am manually writing every day like as

Load

AAA,

BBB,

CCC;

Sql Select

AAA,

BBB,

CCC

Where CCC IN('51',52');    

My question is I would like to give the CCC variable value numbers in excel file or in a text file.

Thanks in advance to advise ...

[MarcoWedel]

Hi,

maybe you could combine Max' solution with a preceding load to the SQL select like this:

tabTemp:
LOAD CCC
From YourExcelFile;

table1:
LOAD *
Where Exists(CCC);
SQL Select
        AAA,
        BBB,
        CCC
From YourDBTable;

DROP Table tabTemp;

or maybe with a join instead of Exists():

table1:
LOAD CCC
From YourExcelFile;

Left Join (table1)
SQL Select
        AAA,
        BBB,
        CCC
From YourDBTable;

Please not that these solutions load all CCC values from your DB, so the script run time might be longer compared to reducing the CCC values already in the select statement.

hope this helps

regards

Marco