create 2 table with 1 excel file

[#1]

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

source:

Date

ID

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??

[avinashelite]

Try like this

Qualify *;

Table1:

Date,

ID,

Sale

from

Source;

Table2:

Date,

ID,

Sale

from

Source;

[jonathandienst]

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.

[priyasawant]

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

[#5]

Thank You, it work!