Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
crispolo
New Contributor III

compose table and check the values inside

Hi guys,

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

  • id_code
  • date (MM/YYYY)
  • status

and I would make this action in this order:

  1. I would load the values from the first table ;
  2. I would load the values from the next table only if

              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!!!

2 Replies
Highlighted
vinieme12
Esteemed Contributor II

Re: compose table and check the values inside

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 ?

Highlighted
crispolo
New Contributor III

Re: compose table and check the values inside

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

    

id_codestatusdate
x234y-04/2017
false (there is)true (there isn't)false (there is)

so the triple should be discarded