Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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)
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.
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.
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;
Like this?
I think so.... just make sure that you have used the name Temp for your inner join table
Apologize for the bad typing
Ahh yes. I do have the Temp name in place. Okay - thanks! I shall try it!