Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

One Excel sheet into two tables

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

1 Solution

Accepted Solutions
Not applicable

One Excel sheet into two tables

before the load statement, place TABLENAME:

so it would look like:

Table1:

Load

9 Replies
Not applicable

One Excel sheet into two tables

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

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

Not applicable

One Excel sheet into two tables

How do I name the tables accordingly?

Not applicable

One Excel sheet into two tables

before the load statement, place TABLENAME:

so it would look like:

Table1:

Load

One Excel sheet into two tables

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

Not applicable

One Excel sheet into two tables

Thanks a bunch!

One Excel sheet into two tables

Hi,

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

Rgds

Anand

Not applicable

One Excel sheet into two tables

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

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