Import by other column values

[AmCh]

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.

[chrismarlow · Accepted solution]

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');

[Elliot145]

---

@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.