-
Connecting to an Excel file in Microsoft Teams
Good Day, I want to connect Domo to a file stored in Microsoft Teams. Has anyone done this? Love to get some instructions on exporting data out of an excel document stored and updated in teams to push data into Domo. Thanks, Gordon
-
How do i trim out an email address from a field with a string?
How do i trim out an email address from a field with a string? Example of Field: Yes, we accept this current pricing and would like to proceed with this order. Thank you, Bob Dole Lab Research Analyst Poss Lab—Dole University bob.dole@some.edu Thanks
-
Dividing in SQL
I currently have this code: categorizing some leads. Select `Year-Month` ,`Lead Source` ,`Product Line` ,`Product Models` ,`Country` ,`Early Stage No Movement` ,`Stage 0 to Early` ,`Early to Lost` ,`Early to Won` ,`Early to Late` ,`Late to Lost` ,`Late to Won` ,Sum(`Early to Lost`+`Early to Won`+`Early to Late`) AS 'Total…
-
How do you change the order date "2020-01-06T16:56:00" to the first day of the month?
How do you change the order date "2020-01-06T16:56:00" to the first day of the month? Via transform.
-
Connect Domo to Salesforce
My company already has Salesforce, and that particular instance is connected to Domo. Our company acquired a new company that has Salesforce which I am attempting to connect to Domo. While attempting to do so, when I select to add an additional account the single sign-on kicks in and automatically reconnects me to the…
-
How do I delete records in an ETL data flow?
Good Day, I have an ETL data flow that is recursive in nature updating Google Analytics data on a daily basis. A subset of data was missing so I appended another dataset in the flow which was ultimately in error. I am attempting to delete the data which was ultimately in error and replace it with new data. I'm not sure how…
-
I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL...
I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL, so that I can group by month etc.
-
I have a Google Sheet that pulls in the last 7 days of Adwords data.
I have a Google Sheet that pulls in the last 7 days of Adwords data. I am attempting to create a dataset that appends this data without creating duplicates. I would love it if someone can provide feedback on how to accomplish this. Thanks.
-
I would like to create a column segmenting the contents of another column into one of two classes.
I would like to create a column segmenting the contents of another column into one of two classes. The column contents either begins with "o" or "w". What would be the best approach to create another column classifying the "o" as "site one" "w" as "site two"? Thanks
-
In MySQL utilizing the Transform property, my where clause is not delivering the expected results.
In MySQL utilizing the Transform property, my where clause is not delivering the expected results. I cannot limit the data I am pulling in thus using the transform property to only look at the date from 01-2016. Here is a snippet of the code: SELECT DATE_FORMAT(p.`date`,'%m-%Y') AS Date, p.`Campaign`, p.`Cost`, CASE WHEN…
-
Using MYSQL transform how would I convert a date field mm/dd/yyyy to mm/yyyy?
Using MYSQL transform how would I convert/create a date field changing mm/dd/yyyy to mm/yyyy?
