Load X if exists A else load B

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

Hi,

Table A:

Artid, ArtLev, Vlgnr

658	ABC	1
658	BCA	2
658	DGE	3
659	ABB	2
659	BBE	3
670	FHG	1

In table A 'Artid' has multiple values sorted by 'Vlgnr'. But sometimes Vlngr 1 of 2 doesn't exist but 3,4,5 etc do.

I want to load ArtLev where Vlgnr = 1, if 1 doesn't exists i want to load 2.

Can anyone help?

Re: Load X if exists A else load B

sunny_talwar — Fri, 03 May 2019 13:09:53 GMT

May be just this

Table: LOAD * INLINE [ Artid, ArtLev, Vlgnr 658, ABC, 1 658, BCA, 2 658, DGE, 3 659, ABB, 2 659, BBE, 3 670, FHG, 1 ]; Right Join (Table) LOAD Artid, Min(Vlgnr) as Vlgnr Resident Table Group By Artid;

topic Re: Load X if exists A else load B in QlikView

Load X if exists A else load B

Re: Load X if exists A else load B