Best Of
Re: Keeping only the latest date for unique ID
You would use a rank & window tile in Magic ETL. You would rank your data on date in descending order partitioned by the ID field. You would then use a filter tile to only keep rows where rank = 1.
If you get stuck let me know!
Re: How to add hyperlink in the table
There's an existing request in the Idea Exchange I'd recommend upvoting:
Re: Assigning Students to Various Organizations
This is an interesting one. First, your student version will be the same as the full version, from what I understand.
I would start by creating a running total of the organization "vacancies" by the highest priority. You would use the rank & window tile for this. This would allow you to create a start and ending amount. For example, if each org had 10 vacancies, the highest priority org would have a start of 0 and ending of 10. The 2nd org would have a start of 11 and ending of 20, etc.
On the student dataset, you would use the rank & window tile to create a ranking of students based on their score from 1 to x number of students.
Add a constant to each datastet and then join the two on that constant. This will temporarily link every student to every organization.
Next, add a filter tile where the student rank is between the organization start and end counts.
This KB article about Rank & Window will help you.
Re: Beast Mode Approach to Eliminate Field Character
@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :)
Should be:
REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'>','')
Re: Beast Mode Approach to Eliminate Field Character
@afieweger If it is always the same character that is showing up, then you can wrap your entire statement in a REPLACE function to remove all instances of the '>' character like this:
REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'<','')
Re: Execution order of AND/OR in case when statement
Regarding question 2 it will evaluate it in the orders of parenthesis first and then AND/OR equally going left to right so you're correct in that it will evaluate it like (A AND B) Or C ) AND D
Re: DOMO Tag report
@A_Benincasa If you create an ETL to join the Dataset Tags report to the Datasets report (also available in the DomoStats connector) you can pull in other details from the dataset, including owner