If Match Statement

[#1]

Questions:

1 - Can I write an If(Match) statement as a Maser Item?

2. If yes - then what am I doing wrong with expression -

  - if(match({<transcript_status_code={"A","X"}, category ={'Skill Area 01/08 }>}), employee_first_name&' '&employee_last_name)

3. If no - what are my other options? Just writing it in the script?

[sunny_talwar]

I guess you are combining If and set analysis... try like this

If(Match(transcript_status_code, 'A', 'X') and category = 'Skill Area 01/08', employee_first_name&' '&employee_last_name)

[#3]

I'm trying to make a Maser Item (Dimension) that will be a drilldown.

One Field I have (Work_Name)

The Second will be only the name of the Employee whom has the A or X Transcript Status for the Category.

But this doesn't work.

It's giving me the count but not the detail. Below is what I am applying to the drill - down in the chart.

[#4]

So I have come to find out that the If Match statement I am trying to write within the Dashboard won't work. I believe I need to write it in the script. Here's my problem -

I have 5 SQL statements. I save them all to a QVD file and then I "drop" the table.

Then at the end I do an Inner Join on all 5 tables.

I want to create IF Match statements somewhere in there... I just don't know where or how I would do it. The Statements I need to create have fields from multiple SQL within the app.

See example.

The 5 Circled are my SQL Statements -

At the bottom of each is where I store the SQL to a QVD. See below.

Then I have my Inner Joins for the QVD files.

I want to create another SECTION to where I can write Conditions (IF Match) statements that could potentially have fields from multiple sections in one IF Match.

Any and all help on how to do this would be great.

[sunny_talwar · Accepted solution]

May be a final resident load after all the joins to create the if statement

Temp:

LOAD *

FROM ...;

Inner Join (Temp)

LOAD *

FROM ....

....

FinalTable:

LOAD *,

           If Statement here.....

Resident Temp;

DROP Table Temp;

[#6]

Like this?

[sunny_talwar]

I think so.... just make sure that you have used the name Temp for your inner join table

Apologize for the bad typing

[#8]

Ahh yes. I do have the Temp name in place. Okay - thanks! I shall try it!