topic Re: Load data based on Date in QlikView

Load data based on Date

Wed, 25 Nov 2020 16:16:04 GMT

Iam very new Qlikview, Iam loading the data from 2 XLSX files.

1st file is having the data EmpID, Date, Addr etc,

2nd file : EmpId, Date From , Date To, AccessTime etc.

my requirement is to load the Emp data based on date.

Ex: Select * from Table1 inner join table2 on T1.Empid = T2.Empid and T1.Date between T2.Date From and T2.Date To.

How can i write the script for this condition.

regards

sudhakar

Re: Load data based on Date

german24 — Mon, 13 Mar 2017 13:16:17 GMT

Hi,

try this...

T1:

LOAD EmpID AS Empid,

FROM

[Table1.xlsx]

(biff, embedded labels, table is [Sheet$]);

//T2:

Inner Join(T1)

LOAD Empid,

FROM

[Table2.xlsx]

(biff, embedded labels, table is [Sheet$])

Where Date >= 'DD/MM/YYYY' and Date <= 'DD/MM/YYYY';

Just the field EmpID must be equal en the two tables.

Best regards,

German

Re: Load data based on Date

aarkay29 — Mon, 13 Mar 2017 13:25:57 GMT

May be This:

TABLE1:

LOAD

EmpID,

Date,

Addr

FROM

TABLE1;

NNER JOIN

INTERVAL MATCH(Date,EmpID)

LOAD

Date From ,

Date To,

EmpID

FROM

TABLE2;

Re: Load data based on Date

Mon, 20 Mar 2017 04:14:25 GMT

Thank you all,

@Aar Kay : 'Interval Match' function solved the issue.

regards

sudhakar.

Re: Load data based on Date

oknotsen — Mon, 20 Mar 2017 07:59:19 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

Re: Load data based on Date

oknotsen — Tue, 21 Mar 2017 08:22:02 GMT

It is nice that you have voted me as "Helpful" , but the idea of my post was to see if your question is answered (by you marking the "Correct Answer", so the topic will be flagged answered) or having you post what part you still need help with.