topic Re: How to get the Date from the Table Name in QlikView

How to get the Date from the Table Name

Mon, 01 Oct 2012 04:19:21 GMT

Hi,

i really need help, i am trying to load data which is the Table name contains the date, since im already done with the loading, my problem is. i need to get the date from the table name itself.

Table Name is like this:

HDMF_20120210

HDMF_20120431

HDMF_20110521

I want to generate the date from Table name and connect it to my Master Calendar.

Please HELP ME...

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 04:41:39 GMT

Hi,

You can use the Function Filename() while loading your table.

SAMPLE:

LOAD

Data,

FileName() as RAW_Tablename,

MakeDate(mid(FileName(),6,4), mid(FileName(),10,2), mid(FileName(),12,2)) as DATE

FROM

C:\Users\alexis.tan\Desktop\HDMF_20120210.xlsx

(ooxml, embedded labels, table is Sheet1);

Something like this.

Regards,

Alex

Re: How to get the Date from the Table Name

Anonymous — Mon, 01 Oct 2012 05:22:12 GMT

Use this which will give you another column with the date field

LOAD

[Pag-ibig No.],
[Last Name],
[First Name],
Initial,
[Employee Contribution],
[Employer Contribution],
Birthday,
MakeDate(mid(FileName(),6,4), mid(FileName(),10,2), mid(FileName(),12,2)) as DATE

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq

);

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 05:42:22 GMT

Hi Alex,

thank you so much! I got the answer already. thanks for your help.

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 06:06:35 GMT

wow I gave the correct answer first but only helpful? nice

anyway, no problem, glad to have helped

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 06:07:54 GMT

Anyway Alex,

just curious, why does the answer you gave me has 3 parameters? thanks

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 06:08:56 GMT

did i? i maybe just an accident..

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 06:09:57 GMT

i marked your answer as a correct answer. hehe, well anyway, let me umark the helpful answer.haha!

Re: How to get the Date from the Table Name

Mon, 01 Oct 2012 06:53:52 GMT

I looked after seeing this in my inbox to tell you that you dont have to since I don't really care if you tag me as correct answer or not (I even said im glad to have helped). But unmarking me EVEN just as helpful o.o" THANK YOU? no points for me after I gave the answer I guess.

sanuela_jro wrote:
i marked your answer as a correct answer. hehe, well anyway, let me umark the helpful answer.haha!

GoodLuck