topic loading data in QlikView

loading data

Fri, 22 Jan 2010 13:15:58 GMT

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 — Fri, 22 Jan 2010 13:54:44 GMT

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.

Fri, 22 Jan 2010 15:11:36 GMT

Thanks for the help 🙂