topic Re: Load a table field twice from a table with different names in QlikView

Load a table field twice from a table with different names

Sat, 19 Jul 2014 08:14:51 GMT

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 — Sat, 19 Jul 2014 09:14:57 GMT

Yes it is possible..

Load

CustomerID,

InvoiceDate,

InvoiceAmount,

CustomerID as CustID

From TableName......

fkeuroglian — Sat, 19 Jul 2014 23:05:18 GMT

Yes you can

Load Field1

Field2

Field3

Field1 as AnotherField

from tableA;

Good Luck

Fernando

SunilChauhan — Sun, 20 Jul 2014 03:55:11 GMT

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

Sun, 20 Jul 2014 07:46:46 GMT

ya you can

Load EmployeeID,

EmployeeID as ID,

EmployeeName

from table;