Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mromrod22
Partner - Contributor III
Partner - Contributor III

Delete record

Hi community,

I need drop a record in a table. Explain me with a example:

I have this table like history:

ID, NAME, MONTHYEAR, TIME, AGE

1, Ned, 012018, 22:00:13, 32,

2, George, 012018, 22:18:45, null,

3, Phill, 012018, 23:02:25, null,

4, Lucas, 012018, 23:15:00, 19,

5, Fred, 012018, 23:55:59, 28;

In latest load, I receive the age of Fred, and must update the row. Insert new record:

ID, NAME, MONTHYEAR, TIME, AGE

3, Phill, 022018, 23:02:25, 28,

6. Joe, 022018, 15:15:15, 30;

And now must drop the record of this name with age null.

The expected result:

ID, NAME, MONTHYEAR, TIME, AGE

1, Ned, 012018, 22:00:13, 32,

2, George, 012018, 22:18:45, null,

3, Phill, 012018, 23:02:25, 28,

4, Lucas, 022018, 23:15:00, 19,

5, Fred, 022018, 23:55:59, 28,

6, Joe, 022018, 15: 15:15, 30;

All the process must be dinamic.

I must drop a record of history, and replace with new row.

Any help, please?

Very thanks.

2 Replies
PrashantSangle

It is type of Incremental load in qlikview.

Incremental Load on QVD

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
mdmukramali
Specialist III
Specialist III

Hi,

FYI...

Data_temp:

LOAD

Date(Max(Date#(MONTHYEAR,'MMYYYY')),'MMYYYY')  as MaxDate

FROM

(qvd);

LET vMaxYear=Peek('MaxDate',0,'Data_temp');

DROP Table Data_temp;

Employees:

LOAD * Inline [

ID, NAME, MONTHYEAR, TIME, AGE

3, Phill, 022018, 23:02:25, 28

6, Joe, 022018, 15:15:15, 30

]

Where Date#(MONTHYEAR)>$(vMaxYear);

Concatenate(Employees)

LOAD * Inline

[

ID, NAME, MONTHYEAR, TIME, AGE

1, Ned, 012018, 22:00:13, 32

2, George, 012018, 22:18:45,

3, Phill, 012018, 23:02:25,

4, Lucas, 012018, 23:15:00, 19

5, Fred, 012018, 23:55:59, 28

]

Where NOT Exists(ID);

STORE Employees into D:\QVW Files\Employees.qvd(qvd);