What the $(expansion) am I doing wrong

[dgreenberg]

let vEngNumber=peek('ePartner',$(vRand),'Sampling1');

This works and returns a value like Greenberg, Dan

Where I am having trouble is

Sampling2:

Load

  eEngNumber,

  ePartner,

  [Engagement Start Date]

Resident Sampling1

where ePartner <>  $(vPartnerB);

I need to wrap the $(vPartnerB) with single quotes otherwise it's interpreted as

where ePartner <>Greenberg,Dan

what I want is

where ePartner <> 'Greenberg,Dan'

What am I doing wrong?

[sunny_talwar]

vEngNumber is infact vPartnerB is my guess.

I might be totally wrong

[harsh44_bhatia]

Hello Swuehl,

Even i would like to clear this point. I was too struggling with the same issue.

if(match([Report Name], '$(vReportList)'  ), 1 ,0) as Flag

vReportList though given in single quotes with DSE was not working. The solution provided by Sunny worked for me.

I did see the logs where the '$()' was converting the string to: 'hjbjhb'',''cvsdc'',''xcd'',''csasdc'

So each single quote withing the string was converted to double quote, posibily that was the reason match function did not work. But again i am confused why would this happen.

--

Harshit