I wonder if it is possible to use a variable as a table name.
Explanation, i have a lot of reportings and i would love to ad a variable to a tabel name.
vDate = 20130901
the table name from the file is [IZ] and i would love to rename the table name like this $(vDate) IZ
THX in advance.
Yes ,should not be a big problem. Have you tried something like
Load ... From ...;
Yes you can use variable as table name. See the below script:
LOAD * INLINE [Dept, Name, SalesInventory, A, 10Inventory, B, 15Inventory, D, 2Sales, A, 14Sales, C, 30];set vtabname = 'Sales';Test:
Hope this help,
Retrieving data ...