creating tables from already loaded tables

[Anonymous]

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.

[tresesco]

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]

Hi

Please refer the exists concept.

http://community.qlik.com/message/234978#234978

Hope tat helps

[kaushiknsolanki]

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]

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