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

[sonysree88]

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)

[Brett_Bleess]

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