“Where” clause in Expressions

[bvssudhakar]

Hello Experts

Here I am having two doubts can you guys please help me from below mentioned doubts:

1.How to write the “where” clause in Expressions

For example:

I want count(candidateID) where placementdate is not null (can you guys elaborate this please)

2. How to change the names of values in our columns

For Example:

I have one column named as Status, In that Column values are 1,0 now i want to replace those values with open, close. i am not getting the idea how to change the values if it is excel we can modify but i am taking query from Sql Server Database.

Please Help out from this as soon as possible guys

Thank you in advance

[sunny_talwar]

I hope you are doing this on the general tab and not the expressions tab?

[bvssudhakar]

I tried in load script also but it's not showing in fields pane, can you check the attached images it is correct or wrong

[sunny_talwar]

So, you need to use Preceding Load here

RMS:

LOAD *,

     Pick(Match(ishotjob, -1, 0), 'Open', 'Close') as JobStatus;

SELECT ....

[bvssudhakar]

Hi Anil,

I tried this formula Count({<placementdate -= {"=Null()"}>} candidateID)

This is also working

Thank you for your help also

[bvssudhakar]

Hi Sunny,

Thank you, I forgot the pattern thank you for the help now it is working.

Now i have two more questions i will create separate discussion for them

And For which answer i want give the correct answer,... for this one or previous 1st question

[sunny_talwar]

That is for you to decide... but you can always mark helpful responses for any/all answers which you thought were helpful.

Best,

Sunny

[debabrata_sahoo]

In pick match case how can we use ELSE statement.