Best Of
Re: Adobe Analytics Legacy backfill for static start, moving end date
The connectors currently don't support functionality like this doing a historical backfill. You'd need to do it manually.
Text analysis
I have a survey where the answer to many of the questions are open-ended.
So I have hundreds of responses for each question.
I created a word cloud, to see the responses, but I want to be able to do a sentiment analysis or a word analysis.
For example, if the question is "Why do you want a career in nutrition?", there are hundreds of different answers. And very few of them have exactly answer. But there are many that include certain phrases like "helping others".
So I want to be able to see those key terms/phrases, and have them counted automatically.
How do I go about doing that?
Thanks!
Re: Is there a way to dynamically select the nth row of a table?
You can partition on multiple fields for your ranking. It would be helpful if you could maybe do a screen recording where you talk and walk through what you are trying to accomplish. Or I'd be happy to set up a call with you to take a look at it. Once again, I am pretty sure we could find a solution - just not sure exactly what it is you're trying to do.
Re: Is there a way to dynamically select the nth row of a table?
I agree with @ColemenWilson that I think this could be possible, but you need to supply more information as to how you go about determining the "X" row of the table. Your drill path card will automatically be filtered by what you clicked on in your main bar chart, you can have additional filters already applied in your drill path card. Drill path cards can also be built on different datasets than the main card. This may help you as you think through the design of your cards.
Re: Is there a way to dynamically select the nth row of a table?
I believe this actually is possible, but I think I need a bit more information about what you are trying to do. You can assign a row number to every row of data in magic ETL, but it will be fixed and wont change from filters in your card or drill path. You can also use a beastmode that will be dynamic and change based on what filters you apply, something like this:
RANK(`some field`) OVER (PARTITION BY `some other field` ORDER BY `another field` DESC)
The problem is, you can't preselect for a certain dynamic row, lets say row 5, because once a filter or drill down occurs, row 5 changes. So the only way to accomplish what I THINK you are trying to do is to give every row a ranking with a partition - the same partition that would occur in the drill down - and then filter the drill path to only return that row.
So for example, you have a card with months on the x-axis and revenue amounts as the y-axis. In magic ETL you do a ranking partitioned on month. Then you setup a drill path with a filter to only show row 5. Each month will have a row 5 associated with that month because of the partition. So if you drill into the January month you would see the 5th row of data with January as the month, and when you click February you would see the 5th row of data associated with February and so on.
Re: Workbench Schedule Jobs are not working .
Give your machine a reboot that typically solves problems I have with workbench.
Re: Workbench Schedule Jobs are not working .
@Ajita If you haven't already, try manually running the jobs to see if they are successful. If they still fail then I suggest the following:
- Verify that the Workbench user is still logged in. If that user recently had a changed or expired password, then you will need to re-authenticate in Workbench with the new credentials
- If your jobs use impersonation, check whether those credentials have changed as well
- Check that Workbench still has access to the data source and that the data has not moved or changed
Hopefully this points you in the right direction, but if you are still having issues feel free to share some Workbench logs from the failing jobs so we can look into it further.
Re: I need to convert a text column to date in ETL
If you have garbage data which doesn't match your date format ('Day' in your example) it may not be simple enough to just convert it to a date. You may need to conditionally set your date value:
CASE WHEN REGEXP_LIKE(`date_field`, '^\d{4}-\d{2}-\d{2}$') THEN
STR_TO_DATE(`date_field`, '%Y-%m-%d')
END
Re: Assigning Students to Various Organizations
@MarkSnodgrass Awesome solution! I immediately thought that this would have to be a loop in python but I love your non-python solution!
Re: DOMO Tag report
@A_Benincasa Here is an example of what this would look like. I actually used the "Dataset Details" report from the Domo Governance Connector instead of the DomoStats connector since it already includes the Owner Name instead of just the Owner ID. Note that if you want to only include datasets with the "Delete" tag in your final output you can change the Join Type from "Left Outer" to "Inner".
