topic Re: Import File .xls: more sheets in QlikView

Import File .xls: more sheets

fmazzarelli — Thu, 04 Jun 2015 09:25:44 GMT

hi,

a xls file is composed of more sheets.

Could I append data into a single table?

Re: Import File .xls: more sheets

Thu, 04 Jun 2015 09:36:07 GMT

Hi Fabio,

Yes you can

FOR EACH vTab IN GENERO, FEBRERO, MARZO ....

load * from table (...... , $(vTab));

best regards

Chris

Re: Import File .xls: more sheets

fmazzarelli — Thu, 04 Jun 2015 10:28:43 GMT

could you suggest me the correct form?

FOR EACH vTab IN GENNAIO, FEBBRAIO, MARZO, APRILE, MAGGIO GIUGNO, LUGLIO

CrossTable(Prodotto, Quantità, 4)

LOAD *

FROM

(ooxml, embedded labels, table is GENNAIO, filters(

Remove(Row, Pos(Top, 2)),

Remove(Row, Pos(Top, 531)),

Remove(Row, Pos(Top, 530)),

Remove(Row, Pos(Top, 529)),

Remove(Row, Pos(Top, 528)),

Remove(Row, Pos(Top, 527)),

Remove(Row, Pos(Top, 525)),

Remove(Row, Pos(Top, 523)),

Remove(Row, Pos(Top, 522)),

Remove(Row, Pos(Top, 523)),

Remove(Row, Pos(Top, 522)),

), $(vTab));

Re: Import File .xls: more sheets

Thu, 04 Jun 2015 10:33:43 GMT

i would suggest you load first raw data in one tmp table and then do your transformation into a final table

Chris

Re: Import File .xls: more sheets

fmazzarelli — Thu, 04 Jun 2015 10:48:25 GMT

hi,

could I have an example?

Re: Import File .xls: more sheets

Thu, 04 Jun 2015 12:16:57 GMT

here is a FOR EACH example

FOR EACH vSheet IN 'GENNAIO', 'FEBBRAIO', 'MARZO', 'APRILE', 'MAGGIO', 'GIUGNO', 'LUGLIO'

Table:

LOAD

....

FROM [<FileName>] (ooxml, embedded labels, table is [$(vSheet)])

;

Chris

Re: Import File .xls: more sheets

fmazzarelli — Thu, 04 Jun 2015 20:15:33 GMT

Houston Houston we have a problem...

Sheets have the same name of column.

------------------------------------

gennaio

column: Name

------------------------------------

febbraio

column: Name

------------------------------------

marzo

column: Name

------------------------------------

using crosstable I must have unambiguous name.

Any suggest?

Re: Import File .xls: more sheets

Wed, 10 Jun 2015 14:42:15 GMT

hi Fabio,

Give to the table the name of $(vSheet):

use "noconcatenate"

and at the end of the 1st FOR EACH...NEXT, do a second to concatenate all table into a single one

enjoy it

Chris