topic How to Load Multiple Tables With the Same Fields in QlikView

How to Load Multiple Tables With the Same Fields

Thu, 28 Apr 2016 21:15:47 GMT

Hello,

I am new to QlikView, and I am having difficulties loading tables using Edit Script.

I am using some tables (.xls) with Census data. There are 5 tables in all (AllRaces, WhiteAlone, BlackAlone, etc), and 5 .xls files. The tables have the same fields (columns). When I 'Reload', only the AllRaces table is loaded.

AllRaces << allRaces$ 105 Lines fetched

AllRaces << whiteAlone$ 210 Lines fetched

AllRaces << blackAlone$ 315 Lines fetched

AllRaces << asianAlone$ 420 Lines fetched

AllRaces << hispanicAlone$ 525 Lines fetched

Script looks like this:

AllRaces:

LOAD Characteristic,

Total,

[Under $5,000],

[$5,000 to $9,999],

[$10,000 to $14,999],

[$15,000 to $19,999],

[$20,000 to $24,999],

[$25,000 to $29,999],

[$30,000 to $34,999],

[$35,000 to $39,999],

[$40,000 to $44,999],

[$45,000 to $49,999],

[$50,000 to $54,999],

[$55,000 to $59,999],

[$60,000 to $64,999],

[$65,000 to $69,999],

[$70,000 to $74,999],

[$75,000 to $79,999],

[$80,000 to $84,999],

[$85,000 to $89,999],

[$90,000 to $94,999],

[$95,000 to $99,999],

[$100,000 to $104,999],

[$105,000 to $109,999],

[$110,000 to $114,999],

[$115,000 to $119,999],

[$120,000 to $124,999],

[$125,000 to $129,999],

[$130,000 to $134,999],

[$135,000 to $139,999],

[$140,000 to $144,999],

[$145,000 to $149,999],

[$150,000 to $154,999],

[$155,000 to $159,999],

[$160,000 to $164,999],

[$165,000 to $169,999],

[$170,000 to $174,999],

[$175,000 to $179,999],

[$180,000 to $184,999],

[$185,000 to $189,999],

[$190,000 to $194,999],

[$195,000 to $199,999],

[$200,000 and over],

[Median income],

F45,

[Mean income],

F47,

[Gini ratio],

F49,

[Income per household member],

F51

FROM

DataSet\allRaces.xls

(biff, embedded labels, table is allRaces$);

WhiteAlone:

LOAD Characteristic,

Total,

[Under $5,000],

[$5,000 to $9,999],

[$10,000 to $14,999],

[$15,000 to $19,999],

[$20,000 to $24,999],

[$25,000 to $29,999],

[$30,000 to $34,999],

[$35,000 to $39,999],

[$40,000 to $44,999],

[$45,000 to $49,999],

[$50,000 to $54,999],

[$55,000 to $59,999],

[$60,000 to $64,999],

[$65,000 to $69,999],

[$70,000 to $74,999],

[$75,000 to $79,999],

[$80,000 to $84,999],

[$85,000 to $89,999],

[$90,000 to $94,999],

[$95,000 to $99,999],

[$100,000 to $104,999],

[$105,000 to $109,999],

[$110,000 to $114,999],

[$115,000 to $119,999],

[$120,000 to $124,999],

[$125,000 to $129,999],

[$130,000 to $134,999],

[$135,000 to $139,999],

[$140,000 to $144,999],

[$145,000 to $149,999],

[$150,000 to $154,999],

[$155,000 to $159,999],

[$160,000 to $164,999],

[$165,000 to $169,999],

[$170,000 to $174,999],

[$175,000 to $179,999],

[$180,000 to $184,999],

[$185,000 to $189,999],

[$190,000 to $194,999],

[$195,000 to $199,999],

[$200,000 and over],

[Median income],

F45,

[Mean income],

F47,

[Gini ratio],

F49,

[Income per household member],

F51

FROM

DataSet\whiteAlone.xls

(biff, embedded labels, table is whiteAlone$);

...

Any and all help would be greatly appreciated.

Re: How to Load Multiple Tables With the Same Fields

Nicole-Smith — Thu, 28 Apr 2016 21:25:59 GMT

Because all of the fields are the same in all of the tables, QlikView automatically concatenates (unions) them into one single table. If you would like to keep them separate, put "NOCONCATENATE" before the LOAD (example below), or you can rename at least one of the fields so that all of the fields are not the same in all of the tables.

Example:

AllRaces:

LOAD Characteristic,

Total,

[Under $5,000],

[$5,000 to $9,999],

[$10,000 to $14,999],

[$15,000 to $19,999],

[$20,000 to $24,999],

[$25,000 to $29,999],

[$30,000 to $34,999],

[$35,000 to $39,999],

[$40,000 to $44,999],

[$45,000 to $49,999],

[$50,000 to $54,999],

[$55,000 to $59,999],

[$60,000 to $64,999],

[$65,000 to $69,999],

[$70,000 to $74,999],

[$75,000 to $79,999],

[$80,000 to $84,999],

[$85,000 to $89,999],

[$90,000 to $94,999],

[$95,000 to $99,999],

[$100,000 to $104,999],

[$105,000 to $109,999],

[$110,000 to $114,999],

[$115,000 to $119,999],

[$120,000 to $124,999],

[$125,000 to $129,999],

[$130,000 to $134,999],

[$135,000 to $139,999],

[$140,000 to $144,999],

[$145,000 to $149,999],

[$150,000 to $154,999],

[$155,000 to $159,999],

[$160,000 to $164,999],

[$165,000 to $169,999],

[$170,000 to $174,999],

[$175,000 to $179,999],

[$180,000 to $184,999],

[$185,000 to $189,999],

[$190,000 to $194,999],

[$195,000 to $199,999],

[$200,000 and over],

[Median income],

F45,

[Mean income],

F47,

[Gini ratio],

F49,

[Income per household member],

F51

FROM

DataSet\allRaces.xls

(biff, embedded labels, table is allRaces$);

WhiteAlone:

NOCONCATENATE LOAD Characteristic,

Total,

[Under $5,000],

[$5,000 to $9,999],

[$10,000 to $14,999],

[$15,000 to $19,999],

[$20,000 to $24,999],

[$25,000 to $29,999],

[$30,000 to $34,999],

[$35,000 to $39,999],

[$40,000 to $44,999],

[$45,000 to $49,999],

[$50,000 to $54,999],

[$55,000 to $59,999],

[$60,000 to $64,999],

[$65,000 to $69,999],

[$70,000 to $74,999],

[$75,000 to $79,999],

[$80,000 to $84,999],

[$85,000 to $89,999],

[$90,000 to $94,999],

[$95,000 to $99,999],

[$100,000 to $104,999],

[$105,000 to $109,999],

[$110,000 to $114,999],

[$115,000 to $119,999],

[$120,000 to $124,999],

[$125,000 to $129,999],

[$130,000 to $134,999],

[$135,000 to $139,999],

[$140,000 to $144,999],

[$145,000 to $149,999],

[$150,000 to $154,999],

[$155,000 to $159,999],

[$160,000 to $164,999],

[$165,000 to $169,999],

[$170,000 to $174,999],

[$175,000 to $179,999],

[$180,000 to $184,999],

[$185,000 to $189,999],

[$190,000 to $194,999],

[$195,000 to $199,999],

[$200,000 and over],

[Median income],

F45,

[Mean income],

F47,

[Gini ratio],

F49,

[Income per household member],

F51

FROM

DataSet\whiteAlone.xls

(biff, embedded labels, table is whiteAlone$);

Re: How to Load Multiple Tables With the Same Fields

Peter_Cammaert — Thu, 28 Apr 2016 21:27:04 GMT

Leave the first LOAD as-is, and add the prefix NOCONCATENATE to all succeeding LOAD statements. You'll end up with five separate internal tables.

Best,

Peter

Re: How to Load Multiple Tables With the Same Fields

Thu, 28 Apr 2016 21:46:36 GMT

Thank you very much Peter! It worked!

Re: How to Load Multiple Tables With the Same Fields

Thu, 28 Apr 2016 21:50:41 GMT

Thank you so much Nicole! It worked!

Re: How to Load Multiple Tables With the Same Fields

Thu, 28 Apr 2016 21:51:24 GMT

So sorry, but I was not able to mark 2 'Correct Answers'.