loading data

[#1]

Hi everyone,

I have an Excel table with telephone numbers and i want to load only a few of them ( 7137441886, 7137441885, 718849222) in the script.

Can you tell me if there is a way to do that.

Thanks!

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

If they are really a few, you can do it either with WHERE clause comparing fields when loading,

LOAD * FROM worksheet.xls WHERE TelephoneField = 'Number' AND TelephoneField = 'Number';

or with MATCH function

LOAD * FROM worksheet.xls WHERE MATCH(TelephoneField, 'Number1', 'Number2', 'Number3') <> 0;

Hope this helps.

[#3]

Thanks for the help 🙂