How to associate the date field from 3 data files?

[ritaaguiar]

Hi there,

I have a Qlik Sense with three .txt data files. Each of the .txt data files has three fields in commom: Utilizador (Username), Data (Date), and Programa (Program).

I woould like to have a field block on my sheet which filters all graphics with data from any of these three files.

How can I get a date field which merges all three and thus affects all graphics from any of the 3 data files?

 

 You may notice that the Username field (Utilizador) and the Program field (Programa) are both successfully filtering all graphics. I would like that to happen to the date field as well.

I have tried to associate the Date fields but everytime I try that it dissassociates the other Username and Program fields...

[pradosh_thakur]

Hi

I don't think you need canonical calendar here to be honest. Your data are same. You can join the tables and can have them in one. Most of the columns in the three tables are same, EXCEPT time, hour, licenses etc. I would advice to join them by creating a key or something.

I would advice you to create sample data(10-20 rows)  if you can't do the modelling and post it, so that we can help you.

regards

Pradosh

[ritaaguiar]

@pradosh_thakur How can I create a key to join the dates?

I have attached sample data to this post.

[pradosh_thakur]

Sure. Let me have a look.

[pradosh_thakur]

Hi Rita,

You don't have the field name in the files. Shall i name them as you have shown in the datamodel?

Thanks
Pradosh

[ritaaguiar]

@pradosh_thakur yeah, sure.

[ritaaguiar]

Hi @pradosh_thakur 

Did you manage to understand how to do it? I haven't been able to associate all three date fields yet 😞

[pradosh_thakur]

Hi @ritaaguiar 

I am sorry. Somehow this skipped my mind. I will get back. Sorry for the delay.

Thanks

Pradosh

[ritaaguiar]

@pradosh_thakur  No worries, thank you for your time and help.

[pradosh_thakur]

I would appreciate if you could just add the column name to the first row of the file and re upload.

[ritaaguiar]

@pradosh_thakur Sure. Meanwhile I have been working on automatically adding the column names and optimizing the script I used to create these data log files. I am attaching the files to this post. Thanks.