Loading only part of a file

[#1]

Hi everyone,

I'm completely new to QV and I'm in trouble with database size.

I have a file, that I will call "File A", with over than 1 million registers, in this file I have informations like StoreID, Address, Number, Phone. In other file, "File B", I have a list with about 100.000 StoresID that I want to analyze, so what I need to do is, Load from File A only those StoreID that are located in File B.

Can Somebody Help me with this Issue ?

Thanks a lot.

[#2]

I don't know what I'm doing wrong. With 2 csv file it WORKS, but I try to do this by loading a QVD file, trough the Import Wizard, what happened was that I've got the "ODBC connection Failed". Should I do something different for this kind of file ?

[#3]

I unfortunately have no experience working with QVD files, so I am not sure.

[Jason_Michaelides]

Please post the exact script you are using.

[#5]

Here It is, let´s supose that "Extração MDTR Mensal_200801.qvd" is the table1 and "PECFARMA.csv" is table2.

Sorry for the long time to reply and thank you all again

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='R$ #.##0,00;(R$ #.##0,00)';

SET TimeFormat='hh:mm:ss';

SET DateFormat='D/M/YYYY';

SET TimestampFormat='D/M/YYYY hh:mm:ss[.fff]';

SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';

SET DayNames='seg;ter;qua;qui;sex;sáb;dom';

LOAD [MDTR Código Região],

     [MDTR Código PDV Key],

     [MDTR Código Distrito],

     [MDTR Código Território Key],

     Clie_Let,

     [MDTR Código Apresentação Key],

     [MDTR Código Atacadista Key],

     SumControl_Units_PeriodNumber,

     SumControl_Values_PeriodNumber,

     [AnoMês Key],

     MDTR.Quantidade,

     MDTR.Valor;

SELECT *

FROM

(qvd);

LOAD Nome,

     SobreNome,

     [MDTR CNPJ PDV],

     Cidade,

     UF

FROM

X:\QlikView\Aplicativos\MDTR_Visitados\Dados\PECFARMA.csv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

LOAD EQUIPE,

     SETOR,

     [MDTR CNPJ PDV],

     [DESCRICAO CAD],

     [END CAD]

FROM

X:\QlikView\Aplicativos\MDTR_Visitados\Dados\CADASTRO_PDVS.xlsx

(ooxml, embedded labels, table is Sheet1);

ODBC CONNECT TO IMS_MDTR_DBFs;

SELECT [OUTLET_COD] AS [MDTR Código PDV Key], [OUTLET_DES], [OUTLET_ADD], [CHAN_COD], [BRICK_CODE], [CNPJ] AS [MDTR CNPJ PDV], [COMPLE_C], [REGI_PTR], [REDE_IND], [CATEGORIA], [BAIRRO], [LOGRADOURO], [TELEFONE], [CEP], [CIDADE], [UF] as [UF MDTR] FROM OUTL537A;

SELECT * FROM PROD537A;

SELECT [PACKCODE] AS [MDTR Código Apresentação Key], * FROM PACK537A;

SELECT LEFT([PERIOD_COD],6) AS [AnoMês Key], [RATE] FROM RATE537A;

[#6]

I did It !!

Thankyou all for the huge help.

Regards.