topic Re: Load variable as table name not working in QlikView

Load variable as table name not working

stjernvd — Wed, 25 Nov 2020 16:16:04 GMT

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

From

File;

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

What am I doing wrong?

Re: Load variable as table name not working

swuehl — Thu, 17 Mar 2016 18:21:39 GMT

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

[$(table)]:

Load

From

File;

Re: Load variable as table name not working

alexpanjhc — Thu, 17 Mar 2016 18:22:21 GMT

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

Re: Load variable as table name not working

sunny_talwar — Thu, 17 Mar 2016 18:24:20 GMT

Try this:

[$(table)]:

Load

From

File;

Re: Load variable as table name not working

Colin-Albert — Thu, 17 Mar 2016 18:25:38 GMT

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.

Re: Load variable as table name not working

Colin-Albert — Thu, 17 Mar 2016 18:31:16 GMT

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

Either of the options below will work.

'$(table)':

Load

From

File;

[$(table)]:

Load

From

File;