Load a table field twice from a table with different names

[#1]

Hey guys,

is it possible in qlikview to ETL a table field twice from a table with different names, so they could be joined with two other different tables?

Many thanks and regards,

[MK_QSL]

Yes it is possible..

Like

Load

     CustomerID,

     InvoiceDate,

     InvoiceAmount,

     CustomerID as CustID

From TableName......

[fkeuroglian]

Yes you can

Load Field1

        Field2

        Field3

        Field1 as AnotherField

from tableA;

Good Luck

Fernando

[SunilChauhan]

one field can be used several time in qlikview only thing you need to rename it

otherwise it will give unique field error.

Load

Region,

Sales*12/100  as discount,

Sales as RegionalSales

from Path

even you could rename the renames field.you can write as many as Load statement on load . like belw

Load *,

RegionalSales as TotalRegionalSales;

Load

Region,

Sales*12/100  as discount,

Sales as RegionalSales

from Path

[#5]

ya you can

Load EmployeeID,

         EmployeeID as ID,

         EmployeeName

from table;