topic Daily qvd data in QlikView

Daily qvd data

jumiprado — Sat, 16 Nov 2024 03:16:46 GMT

Hey guys, i need to create a solution where extract a table everyday and store it in qvd with the date and time when i extract it. but this data then is audit and some fields change, so i need to add into a weekly and monthly qvd with checked info.

In addition, the last data may have rows of an event that occurred on a previous day so i have to detect this new rows

Thanks!

Re: Daily qvd data

dplr-rn — Mon, 17 Jun 2019 19:03:51 GMT

Hi
it is possible .
you load the qvd and concatenate 'todays' data and save it again. it is fairly straightforward. can you explain the challenge with examples possibly
you last sentence regarding events is not clear.

Re: Daily qvd data

jumiprado — Tue, 18 Jun 2019 15:54:32 GMT

Hi!

i have a table from database like this:

ID	input_date	event_date	name	place	mode	description
12357	1/6/2019	30/5/2019	Jhon	Place 1	Mode A	description event mode A
5461132	2/6/2019	2/6/2019	Mary	Place 2	Mode B	description event mode B
1484155	3/6/2019	1/6/2019	Peter	Place 3	Mode A	description event mode A

first of all i need to store it in a qvd with the date and time that was stored

ID	input_date	event_date	name	place	mode	description	qvd_date	qvd_time
12357	1/6/2019	30/5/2019	Jhon	Place 1	Mode A	description event mode A	1/6/2019	07:00
5461132	2/6/2019	2/6/2019	Mary	Place 2	Mode B	description event mode B	2/6/2019	07:00
1484155	3/6/2019	1/6/2019	Peter	Place 3	Mode A	description event mode A	3/6/2019	07:00

Then this new table goes to the audit team where they create new fields

ID	input_date	event_date	name	place	mode	description	qvd_date	qvd_time	audit_event_date	audit_place	audit_mode
12357	1/6/2019	30/5/2019	Jhon	Place 1	Mode A	description event mode A	1/6/2019	07:00	1/6/2019	Place 2	Mode B
5461132	2/6/2019	2/6/2019	Mary	Place 2	Mode B	description event mode B	2/6/2019	07:00	2/6/2019	Place 4	Mode B
1484155	3/6/2019	1/6/2019	Peter	Place 3	Mode A	description event mode A	3/6/2019	07:00	1/6/2019	Place 5	Mode A

In addittion, when the team is auditing some information is added in the database with a previous date that is in audit, so i need to detect the new rows of the table.

Thanks!

Re: Daily qvd data

jumiprado — Wed, 19 Jun 2019 17:52:14 GMT

@dplr-rn

@Anonymous