jlazerus Member

I got this to work by changing the format of the date. STR_TO_DATE(`ReportDate`, "%m/%d/%Y")

Would that replace the data in the `Balance` field for that date only? I still want to keep the rest of the data on the dataset.

I think I was just able to get this to work using both methods. SELECT a.`ID` ,a.`Name` ,a.`Description` ,a.`Value 1` ,a.`Value 2` ,'' as `Value 3` FROM `Dataset 1` a UNION ALL SELECT b.`ID` ,a.`Name` ,b.`Other Description` As `Description` ,'' as `Value 1` ,'' as `Value 2` ,b.`Value 3` FROM `Dataset 2` b LEFT JOIN…

This would work for a regular join but `Description` and `Other Description` will never match. I basically want to append the `Other Description` onto the first dataset table but also bring over all of the other columns.

I'm having this problem too. When creating the application in Azure, you have to specify a redirect URL. Its not supplied by MS. I tried https://localhost but that failed.

Does this tool exist yet?

Good catch. That fixed that error. This is amazing! Thank you so much.

Those are the fields i'm changing and I also tried without the WITH ROLLUP text and am getting the same error.

Same error. And just to validate, the only thing I'm changing on your script is the FROM table in the SELECT and SET sections, right?

It does not error when I create the procedure.

Yes. Those look correct.

Thanks for the reply. When I run this, I get this error on running the Call pivot() The database reported a syntax error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1

You can try converting the date column to text, then uncollapsing, then converting it back to dates.

Any chance you can share a portion of your powershell script? I'm having an issue just getting a token using powershell and the domo api. It looks to be SSL related: Invoke-WebRequest : The underlying connection was closed: An unexpected error occurred on a send.

I'm also having this issue. I see this has been opened for over a year. Has anyone found a solution?

Okay so I just realized that I could run my dataset through another ETL and uncollapse the columns which in turn solves my problem.

Actually, I just tried the same exact thing again and it worked. Weird. Either way, thanks!

Hi, I tried this on a card where I created the drill patch but it did not save the drill path card.

Thank you. I'm not sure why I didn't try that myself but your first solution worked perfectly.

So I'm not sure why but I was able to resolve this by creating two more flows, a mysql flow to count and group and then an ETL to uncollapse the mysql results. The numbers are formatted the same but it seems to work now.

That did work when I put the COUNT around it. Thanks so much. 

So I actually figured out what I was trying to do here, but it led me to two follow up questions. * Is it possible through the custom connector to pull more than 2000 rows of data? (I get an error if I try) * Can someone assist me in pulling nested json objects? See the sample of what I'm trying to get below. I noted on…

That's great, thanks. I'll give those a try.

Okay, I finally figured this out. I needed to add a "Content-Type": "text/csv" to my header because "Accept": "text/csv" was not enough.

Just as an update, I also tried sending a single line non-variable string "a,b,c,d" and am still getting that error. 

Here's a way to split each separation into a row, just in case anyone needs that in the future. select SUBSTRING_INDEX(SUBSTRING_INDEX(Column_Name, '_', numbers.n), '_', -1) name from (select 1 n union all select 2 union all select 3 union all select 4 union all select 5) numbers INNER JOIN tablename on…

Still says 'No Data Exists'

I just don't want to see 1 on my chart when there are really 0. I don't want to count the null field. I just want it to show as 0 on the chart when it is null.

Just to clarify, I'm trying to get a count of the number of distinct system names, even when the field is null. So in those cases, the count would be 0. I did try what you wrote and the error went away, but the chart says 'No data exists'.

Valid query, same error.