topic Re: variables in QlikView

variables

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

hi all,

step 1:

i have a date excel file which as dates in it and i loaded it

ex:

Date:

12-jan-2018

13-jan-2018

step 2:

now i want set variable to store the above date

Step 3:

i want to load the file

ex:

load *

from [..//xyz_12jan2018.xsl]

but instead of file name 12jan2018.xsl i wanna use variable set on step 2, how can i achive that,it used happen dynamically

Re: variables

shiveshsingh — Tue, 23 Jan 2018 11:57:52 GMT

Can you share sample data?

As i see, file name is date and u want to extract date from File name and then what?

Re: variables

Anil_Babu_Samineni — Tue, 23 Jan 2018 12:04:00 GMT

Perhaps something like below?

Sample:

LOAD * Inline [

Date

12-jan-2018

13-jan-2018

];

LET Variable = Peek('Date',0,'Sample');

LOAD Date1

FROM

Files.xlsx

(ooxml, embedded labels, table is '$(Variable)');

Instead third step your needed is this

ex:

load *

from [..//xyz_'$(Variable)'.xsl]

Re: variables

vignesh_s — Tue, 23 Jan 2018 12:04:21 GMT

in step 1 i have loaded a Date file which contains Date field

and i want to set a variable(say the varible is 'v') to store the Date field

later i have one more file to load wich is loaded from [../xyz_2jan2018] but i want to load like [../xyz_$(v)]

Re: variables

shiveshsingh — Tue, 23 Jan 2018 12:13:30 GMT

Date:
load Date_New from Sample.xls
order by Date asc;

Let vDate = Peek('Date_New',0,'Date');

Final:
load * from [../xyz_$(vDate)];

Re: variables

vignesh_s — Tue, 23 Jan 2018 12:14:41 GMT

thanks for the reply anil,but u used Peek('Date',0,'Sample'); what if i have lots of date in it

Re: variables

Anil_Babu_Samineni — Tue, 23 Jan 2018 12:16:33 GMT

May be Loops using Peek() can deserve, But still not sure what your question ending up?

Re: variables

vignesh_s — Tue, 23 Jan 2018 12:21:45 GMT

hi thanks for replay,the date formate in date field is 12-jan-2018 and in file name its like 12jan2018

is that fine if i use without converting date formate

Re: variables

vignesh_s — Tue, 23 Jan 2018 12:23:02 GMT

refer shivesh singh replay my expectation is similar to that

Re: variables

Anil_Babu_Samineni — Tue, 23 Jan 2018 12:24:38 GMT

I have not seen any difference from him and mine

Re: variables

shiveshsingh — Tue, 23 Jan 2018 12:30:53 GMT

U need to convert it into desired format using Date(Date#...

Re: variables

vignesh_s — Tue, 23 Jan 2018 12:37:51 GMT

hi attached text file hope it may understand clearly