Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
stjernvd
Partner - Creator
Partner - Creator

Load variable as table name not working

Hi,

I would like to use a variable that has a date stored in it as my table name, but I keep getting the error: Unknown Statement 01-Feb-2015.

First I load my date:

Date:

Load

Date(Timestamp#(Date,'DD-MMM-YYYY hh.mm.ss TT'),'DD-MMM-YYYY')  as Date (this works the dates look normal)

From

File;

MaxDate:

Date(Max(Date)) as MaxDate (if I only do Max(Date) as MaxDate I get the number 40125 instead of a date)

Resident

Date;

Let vMaxDate = peek('MaxDate',0,'vMaxDate'); (this also works it stores 01-Feb-2015)

Drop table Date;

Drop table MaxDate;

Set table = $(vMaxDate);

$(table):

Load

x

x

x

From

File;

and then I get the Unknown Statement: 01-Feb-2015 error message:

What am I doing wrong?

1 Solution

Accepted Solutions
Colin-Albert

Try using

     Date(Max(Date), 'DDMMYYYY') as MaxDate

to remove the dashes from the date so you use 01FEB2015 rather than 01-FEB-2015

The dash is not an acceptable character in a tablename.

I am not sure why you would want a table name that changes though.

View solution in original post

5 Replies
swuehl
MVP
MVP

Try using [...] around your variable expansion:

[$(table)]:

Load

x

x

x

From

File;

alexpanjhc
Specialist
Specialist

the dash(-) cant be used as part of table name.

sunny_talwar

Try this:

[$(table)]:

Load

x

x

x

From

File;

Colin-Albert

Try using

     Date(Max(Date), 'DDMMYYYY') as MaxDate

to remove the dashes from the date so you use 01FEB2015 rather than 01-FEB-2015

The dash is not an acceptable character in a tablename.

I am not sure why you would want a table name that changes though.

Colin-Albert

You will still need to enclose the variable in square braces or single quotes.

Either of the options below will work.

'$(table)':

Load

x

x

x

From

File;

[$(table)]:

Load

x

x

x

From

File;