Alyc120 Member

Comments

  • We are running any outstanding windows updates now. I have also requested the affected worker to make a new connection from a new spreadsheet to rule out a file corruption in Excel.
  • Thanks ArborRose. We were impacted by the AWS outage Monday morning. Most of my dataflows failed for several hours. This is the only issue since then and it started 2 days later. I did re-authenticate. I will try a reboot to clear cache.
  • I figured it out, I was looking for a complicated answer and it was just CSV, JSON, etc…
  • I worked with BT Partners. They helped me navigate the API (after I spent 8 hours researching how to do it myself to no avail). In addition to working out the details of the API connector, they also and provided JSON code to paste into Magic ETL. I was up and running in a jiffy with their experience. It was worth the…
  • Hi Mark, Thanks. I can dig in DOMO to see what's stale. But I lost a much simpler method which was in Workbench 5.1. Can I add a field to the list of DataSet jobs in WB 5.2? I work with 14 WorkBench connections. I can quickly identify which connection has stale data, but it was beneficial to pull up the specific PC's…
  • I worked around this by adding a CONCAT formula in Magic ETL. My File# needs to be 6 characters long. This worked for me. CASE WHEN LENGTH(File#) = 5 THEN CONCAT('0',File#) WHEN LENGTH(File#) = 4 THEN CONCAT('00',File#) WHEN LENGTH(File#) = 3 THEN CONCAT('000',File#) WHEN LENGTH(File#) = 2 THEN CONCAT('0000',File#) WHEN…