variable creation

[#1]

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 · Accepted solution]

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);

[#3]

I Got Result thank you for helping me.