topic compose table and check the values inside in QlikView

compose table and check the values inside

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I've n table, with n from 1 to 10, every table contains the same field:

and I would make this action in this order:

id_cod and data and status aren't loaded before (note: and like logical operator)

I would repeat the second point from 2-table to n-table.

Furthermore sometimes there may be an error, and the value of field status inside a triple could be '-'

for example: x234y, -, 04/2017

so if so it is happened and in the next table I find the right triple

for example: x234y, active, 04/2017

I would delete the old triple and add the new.

Is this possible?

I hope I have been clear

Thank you!!!

vinieme12 — Fri, 06 Oct 2017 19:07:40 GMT

what if the earlier table had the row

for example: x234y, active, 04/2017

and in the next table

for example: x234y, -, 04/2017

What then ?

Anonymous — Mon, 09 Oct 2017 06:57:11 GMT

at the second step should be the check, on your example

id_code	status	date
x234y	-	04/2017
false (there is)	true (there isn't)	false (there is)

so the triple should be discarded