Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I wanted to try something new, but don't really know where to start and how to do things. I have many files that look like this.
What I want to do is to somehow connect visitors to date and hour. I have a customers table with customer orderID as the key.
1. It is reasonable to make a left join to that table, isn't it?
2. How do I handle that fact that there are many tables like this (1 for each month)? How can I load them into the script without there being 50 tables?
3. How would I visualize this in the best way later on?
I'm aware that there are a great deal of questions, but I'm hoping that someone can share their knowledge 😃
Okay, so I think I managed to answer question 2. I concatenated the tables into one and I'm guessing it's the right way to do it? (this is my first time I do it =D).
Sincerely,
Betty Habtemariam
Ignore question 1 as well. Maybe it's not a good idea to do a left join...?
Sincerely,
Betty Habtemariam
Hi Betty,
As you have figured out the solution for the 1st and 2nd questions , check the below link in QlikBranch:
Time line extension : http://branch.qlik.com/#/project/56728f52d1e497241ae6989d
Thanks,
Sangram