Track records in same base in load process

Anonymous — Fri, 07 Sep 2018 21:06:47 GMT

Dear all,

I´m new with Qlikview and I need a help with the follow:

From a load script like the bellow:

Test_table:

Load

Name

Date_a, // formato (YYYYMMDDHHMMSS)

RegID_a

Resident Base_a

Join

Load

Name

Date_b, // formato (YYYYMMDDHHMMSS)

RegID_b

Resident Base_b

I need to add a field in the above table with the track information of records from Base_a and Base_b.

So, I need a field RegID_ab with the RegID_a information in the lines that came from Base_b with the follow condition:

> From Date_a, what is the grater and nearst Data_b, considering same Name and Flag_a = Flag_b.

In the field Interval, I need the difference between dates (Date_a e Date_b) in seconds.

Exemple of expectation:

Notes:

I need to do this track in load process and not in DB.
As showed in the above example, I can have records in both Bases with no correspondent records in the other base.

Sorry, but I cant download and open qvw files, so please answer with the suggested sript and I will test.

Thanks in advance !!!

topic Track records in same base in load process in QlikView