har_d_har1

@MichelleH The data will be used to generate a card like this. What I have going in are start and end dates of various activities, and a total amount of effort to complete the activity. I'll want to display each activity in its own row in the chart. I'm aware of the issues with removing/adding table columns via ETL, so I…

in Single column dynamic pivot - syntax error Comment by har_d_har1 July 30

@GrantSmith I have since realised that my code is changing the schema and that this is the cause of the error (duh). Rather than update the schema daily, which introduces more potential for errors (I am not a smart man) I have worked around this issue by sticking to a static start date of 1st January. Then the schema only…

in Daily Dataset Update via Python fails on first run each day Comment by har_d_har1 March 2023

To workaround this issue and allow by ETL to complete, I have created a separate ETL dataflow just to produce a table of columns from the Domo Dimensions Calendar, which I then use as an Input DataSet to the above code, essentially removing rows 11-30 above.

in "Column referenced but not found" Python error creating date-sensitive columns in ETL Comment by har_d_har1 January 2023

Dynamic PDP solved this - my organization only uses one Trusted Attribute, which wasn't well represented in my input datasets. Once I figured that out it came together easily.

in How can I create personal cards? Comment by har_d_har1 December 2022

har_d_har1 Member

Comments