topic Re: creating tables from already loaded tables in QlikView

creating tables from already loaded tables

Anonymous — Tue, 06 Aug 2013 04:45:27 GMT

i have a base table loaded to qlikview, now need to create a new table matching some criteia from the base table.

can this be done in qlikview ? am loading data from a sql server database for the base table.

tresB — Tue, 06 Aug 2013 04:52:19 GMT

try something like this:

SQLTable:

Load

;

Select A,B, C From <Your SQL source>;

NoConcatenate // to avoid auto concatenation in any case if you want to take all the fields

NewTable:

Load A, B Resident SQLTable Where <Your condition>; // 'Resident' keyword reads from the loaded table

MayilVahanan — Tue, 06 Aug 2013 04:54:14 GMT

Please refer the exists concept.

Hope tat helps

kaushiknsolanki — Tue, 06 Aug 2013 04:55:25 GMT

Hi,

Use the resident load.

Just like shown below.

Data:

Load Field1,Field2 from XYZ;

Data1:

Load Field1 as City, Field2 as Code resident Data;

Regards,

Kaushik Solanki

CELAMBARASAN — Tue, 06 Aug 2013 05:04:00 GMT

Hi,

You can do this using Resident

I take it as your have the Base table with the table name BaseTable.

NoConcatenate

NewTable:

Load

FieldA,

FieldB,

FieldC

FieldD

Resident BaseTable

Where FieldC>2010 and FieldD>0;

Hope it helps

Celambarasan