-
how to remove duplications in data sets
We have data that gets appended to the data flow for historical purposes. How do we removed the duplication of the data due to appending. The column that would initiate the data remaining is "Date Uploaded". HELP. SPM
-
Pivot Transformation in Magic ETL not Pulling in 4 columns? HELP
Aloha team: Data is coming from Survey monkey; therefore, I have to transform the data from rows to columns. I have 18 columns that I do this with; using one pivot transformation, since all the data is similar (i.e. #1, 2, & 5) (1st pic). The issue is 12 columns are able to transform the data, however, four (2nd pic) is…
-
File of Workbench job moved; created two (2) datasets with the same name in DOMO
Aloha: I had to re-download my workbench onto another remote computer; which moved my file locations for my current jobs. The jobs ran fine; however, when I looked on my DOMO instance, I had two (2) jobs with the same dataset name. What is the easiest fix for this? Thank you, in advance, for any assistance provided. Salina
-
Recursive dataflow Issue - No Data
Aloha All: I have a recursive dataflow that is wiping out my start and end dates when the new data is uploaded. Current data has the start and end dates; however, the historical data is missing the dates. The dates were originally there in the initial upload. My recursive has a join the new data and historical data. Then I…
-
Create a calculated column using beast mode
Aloha: I would like to calculate the following using beast mode, having the results in a new column. Example: column name: Start Date "9/1/2019" column name: Days Ago "2" If column "days ago" has a number in it, then take the date in the "start date" column and subtract it from the number in column "days ago"; resulting in…
-
HTML link to External site Using Values in Table
Aloha All: I am trying to create a hyperlink from the values in a html table. This is what I have so far: CONCAT('<a href= https://www.research.net/r/',`column header name`,'_',`column header name1`,'_',`column header name2`,'?c='`column header name4`,'&PFC='`column header name5`,','`column header name6`,'&PCN='`column…
-
Case Statement Issue: Summing (minutes / 60 = hours) / Count (Distinct)
Aloha, I have been reading thru the boards and still have no solution. Of course, I am still a novice at this....Here goes: If column Specify type of PFC activity: = Video Teleconference Client Contact then sum column "Enter the number of minutes......" / 60; which would give me hours. Then, divide the total hours by the…
-
Error: Failed to parse data
Aloha All: I have the error: Failed to parse data '43269' as type Datetime for column 'Entry Date'. When I pulled the data into Excel to look for the error, I could not find it. This error is on the raw data coming in from Workbench. Any suggestions on how to fix this. Mahalo. SPM