topic One Excel sheet into two tables in QlikView

One Excel sheet into two tables

Wed, 12 Oct 2011 13:33:57 GMT

Hi everyone!

I've stumbled upon a problem with Loading excel data into QV . I have an excel sheet with a lot of different columns that I was to use and several different tables so that I can set relations and keys as I want.

So is it possible to take one excel sheet, split it, and place it as two different tables in QV? I can't split my Excel sheet into two different because it's coming from another source.

Unfortunatly I'm currently using personal edition so I can't open any example files, please post code.

Thanks,

asolsson

One Excel sheet into two tables

Wed, 12 Oct 2011 13:44:59 GMT

Is it possible to split your excel into 2 worksheets? Qlikview loads sees each sheet as a different data source.

That or just load the files you need twice (Seperate the fields you need in each) and name the tables differently.

One Excel sheet into two tables

its_anandrjs — Wed, 12 Oct 2011 13:51:31 GMT

Hi,

I suggest when you load the tables after loading the tables in qlikview use to make resident tables to split then table like

Tab1:

load

From table

Load

Field1,

Field2,

...

Resident Tab1;

load

Field3,

Field4,

Resident Tab1;

some thing like this

Rgds

Anand

One Excel sheet into two tables

Wed, 12 Oct 2011 14:32:24 GMT

How do I name the tables accordingly?

One Excel sheet into two tables

Wed, 12 Oct 2011 14:51:24 GMT

before the load statement, place TABLENAME:

so it would look like:

Table1:

Load

One Excel sheet into two tables

its_anandrjs — Wed, 12 Oct 2011 14:55:56 GMT

Hi,

Try to load tables like

Tab1:

load

Fields.....

From table;

Tab1Copy1:

Load

Resident Tab1;

Tab1Copy2:

Load

Resident Tab1;

Tab1Copy3:

Load

Resident Tab1;

And add your choice of fields on this resident table or otherwise load table twise.

Rgds

Anand

One Excel sheet into two tables

Wed, 12 Oct 2011 14:59:15 GMT

Thanks a bunch!

One Excel sheet into two tables

its_anandrjs — Wed, 12 Oct 2011 15:01:01 GMT

Hi,

You check it my way it is fast and there is you able to make a calculation on that also.

Rgds

Anand

One Excel sheet into two tables

Wed, 12 Oct 2011 17:23:47 GMT

But the resident function means that I have to import all values into one table then take them from there. I don't want to use all the columns in the excelsheet.

One Excel sheet into two tables

its_anandrjs — Wed, 12 Oct 2011 18:24:00 GMT

Hi,

No it is not necesary that you can use tables all fields first load in the resident table and then you use it. Parallel when you load your main table on that after that you load which field you want to load you can specigy in the resident load.

Rgds

Anand