Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Date Synthetic Key File Name Date#

Hello Everybody,

Please your help with the following:

I have 3 tables that im taking the date from the File Name:

Table1:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

Table2:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

Table3:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

 

And this create a Synthetic  Key, how can I get rid of the key?
I tried to put other names to FileName as FileName1 but I had to create different filters, I need to have one filter for date when I select a month, all my graphics take that month.

Thanks!!

4 Replies
Highlighted
MVP
MVP

@nicolearayav  try to concatenate tables

Table1:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

concatenate

Table2:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

concatenate

Table3:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

Highlighted
Contributor
Contributor

Hi,

 

It doesnt work because I have 

Table1:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableA:

load.....

Table2:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableB:

load.....

Table3:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableC:

load.....

I tried to put concatenate between after the table with the Join:
Example:

Table1:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableA:

load.....

Concatenate

Table2:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableB:

load.....

Concatenate

Table3:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....

Join

TableC:

load.....

 

But it doenst work 😞

Highlighted
Digital Support
Digital Support

Here are some Design Blog posts that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

Here is the base URL for that area in case you want to search further on your own for other posts:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
MVP
MVP

@nicolearayav  try below then

Table1:
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....;

Join

TableA:
load.....;

Table2:
noconcatenate
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....;

Join

TableB:
load.....;

Table3:
noconcatenate
LOAD
FileName() as FileName,
Date(Date#((Left(Right(FileName(),12),7)),'MM.YYYY'),'MM.YYYY') as FileDate,

....;

Join

TableC:

load.....;

Final:
LOAD * 
resident Table1;

concatenate
LOAD * 
resident Table2;

concatenate
LOAD * 
resident Table3;

Drop tables Table1,Table2,Table3;