topic Re: create 2 table with 1 excel file in QlikView

create 2 table with 1 excel file

Wed, 25 Nov 2020 16:16:04 GMT

I have a excel and want to upload to qlik to make 2 table:

source:

Date

Sale

Table1:

T1.Date

T1.ID

T1.Sale

Table2:

T2.Date

T2.ID

T2.Sale

Any quick way to do instead of changing the field name one by one??

Re: create 2 table with 1 excel file

avinashelite — Mon, 06 Mar 2017 08:09:38 GMT

Try like this

Qualify *;

Table1:

Date,

ID,

Sale

from

Source;

Table2:

Date,

ID,

Sale

from

Source;

Re: create 2 table with 1 excel file

jonathandienst — Mon, 06 Mar 2017 08:13:36 GMT

This is one way:

QUALIFY *;

T1:

LOAD Date, ID, Sale

FROM ....

T2:

LOAD Date, ID, Sale

FROM ....

UNQUALIFY *;

Rename Table T1 to Table1;

Rename Table T2 to Table2;

Although I am curious to why you would want to do this.

Re: create 2 table with 1 excel file

priyasawant — Mon, 06 Mar 2017 08:18:24 GMT

You can use Qualify before any table, then the Qualified table will be renamed and you will get two tables

Qualify;

Table1:

T1.Date

T1.ID

T1.Sale

Unqualify;

Table2:

T2.Date

T2.ID

T2.Sale

Re: create 2 table with 1 excel file

Mon, 06 Mar 2017 08:23:35 GMT

Thank You, it work!