Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-08-08 12:36 AM

Loading data from Excel

Hello All,

I am loading data from two Excel files A and B .

Excel File A has two field Job, Start Date and Start time. Excel File B has FriceID, Job Name, Start Date and Frequency.

The Problem is that data of Start date field of file A is not matches with data of Start date field of file B. And Data of Job of file A is not exactly similar with data of Job Name of file B, only few records between Job and Job Name are same. So how to connect the two table in Qlikview? 

Thanks & Regards        

1,376 Views
0 Likes
10 Replies
amit_saini
Master III
Master III
‎2014-08-08 02:21 AM

Meenakshi,

Angad is right , Join concept will work in your case. For more details go through the attachment.

Thanks,
AS

Preview file
199 KB
147 Views
0 Likes