Pick 2 values from 1 table to store in variable on script.

sonysree88 — Sat, 16 Nov 2024 18:18:40 GMT

Hi Team,

Earlier in my script of extraction layer.

We have used vId=Peek('Id',0,'Table');

Now I want to show Id =1 then loans if its 2 then deposits.

Can you let me know how to do..

I used this expression

Let vid= pick(Match(Id, 1,2),'deposits','loans')

After this peek or pick we have the script like as below

Select District

Date

From tablename

Where Id=$(vid).

In id=$(vid) I need to show 1,2. So do we need change any thing here.

In this script am getting error after written pick instead of peek.

If I used peek it's getting only 1 in vId.

But I need to show 1,2 both in $(vid)

Re: Pick 2 values from 1 table to store in variable on script.

Brett_Bleess — Thu, 06 Aug 2020 15:21:58 GMT

Likely need to attach QVW so folks can see the data model etc. and the entire script, think it is going to be difficult for folks to respond otherwise, but I may be wrong, we'll see if my comment kicking things back out results in someone having some other ideas for you.

Regards,
Brett

topic Pick 2 values from 1 table to store in variable on script. in QlikView

Pick 2 values from 1 table to store in variable on script.

Re: Pick 2 values from 1 table to store in variable on script.