Hello, Wondering if there's a way to LOOKUP...

expressions
(Jenn M.) #1

Hello,

Wondering if there’s a way to LOOKUP with only partially matched results? For example, I have a table with 2 columns: MODEL NUMBER | PRICE.

I’d like to pull the price data into another table column if the first four of that column’s text string match with the first four of MODEL NUMBER text string.

I assume the LOOKUP expression can be used, but I’m not sure if there is a simple way to accomplish it.

Thanks.

(Jenn M.) #2

@Aleksi_Alkio

Thanks. I implemented the following formula which returns with “ORDERBY does not have a valid input”. TOP(ORDERBY(SELECT(Products[Price],[Model]=[_THISROW].[Shirt Model]), Model, FALSE), 4)

That’s alright though-- if this is not an easy method, I’ll just create another column to enter additional text values to the model if it exceeds over 4 values.

(Aleksi Alkio) #3

You could try to use syntax… TOP(ORDERBY(SELECT(…,4)

(Aleksi Alkio) #4

You can use ORDERBY only with the key column… for example with the

ref field.

(Jenn M.) #5

Ah, got it. Thanks.