Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolearayav
Contributor II
Contributor II

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!!

Labels (6)
4 Replies
Kushal_Chawda

@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,

nicolearayav
Contributor II
Contributor II
Author

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 😞

Brett_Bleess
Former Employee
Former Employee

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.
Kushal_Chawda

@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;