topic Re: Import by other column values in QlikView

Import by other column values

AmCh — Wed, 17 Feb 2021 11:37:29 GMT

Hello all,

I have this table as an example:

Text	Number
a	1
b	2
c	3
a	4
b	5
d	6

I want to get the value from the 'Number' column that corresponds to a particular value from the 'Text' column.

As an example:

I want to get the 6 that corresponds to the value d.

Can anyone help me?

Many thanks in advance.

Re: Import by other column values

chrismarlow — Wed, 17 Feb 2021 16:21:37 GMT

Hi,

How you do this really depends on what you then subsequently want to do with it ...

So you can catch it in a variable using script similar to the below ... if you then want to use it as a variable somewhere in your script.

Cheers,

Chris.

data: LOAD * Inline [ Text, Number a, 1 b, 2 c, 3 a, 4 b, 5 d, 6 ]; data_filter: NoConcatenate Load * Resident data WHERE Number=6; vText=Peek('Text',0,'data_filter');

Re: Import by other column values

Elliot145 — Fri, 19 Feb 2021 04:01:22 GMT

@AmCh wrote:
Hello all,
I have this table as an example:
Text Number
a 1
b 2
c 3
a 4
b 5
d 6

I want to get the value from the 'Number' column that corresponds to a particular value from the 'Text' column.
As an example:
I want to get the 6 that corresponds to the FaceTime value d.
Can anyone help me?
Many thanks in advance.

Much obliged to you for The Sharing.