topic variable creation in QlikView

variable creation

Wed, 28 May 2014 13:21:36 GMT

H community i have tables,

Address:

LOAD AddressID,

AddressLine1,

AddressLine2,

City,

PostalCode,

FROM

E:\xyz\Task\Excel\Address.xlsx

(ooxml, embedded labels, table is Address);

Store:

LOAD StoreID,

StoreName,

SalesPersonID

FROM

E:\xyz\Task\Excel\Store.xlsx

(ooxml, embedded labels, table is Store); i have some more table

in this instead of using the "E:\xyz\Task\Excel\" i need to us a variable

FROM

Variable name\filename.xlsx

How can i do this.

its_anandrjs — Wed, 28 May 2014 13:25:31 GMT

Create a variable like below script and load your table according to variable use

Let vPath = 'E:\xyz\Task\Excel\';

Address:

LOAD AddressID,

AddressLine1,

AddressLine2,

City,

PostalCode,

FROM

$(vPath)Address.xlsx

(ooxml, embedded labels, table is Address);

Store:

LOAD StoreID,

StoreName,

SalesPersonID

FROM

$(vPath)Store.xlsx

(ooxml, embedded labels, table is Store);

Wed, 28 May 2014 13:36:21 GMT

I Got Result thank you for helping me.