Sam_Arigato Member

Comments

  • Hi Jessy, Have you tried all three built-in Parsers? You may need to use the X Path functionality that's under the 'additional options' drop-down in the details section of your connector. The link below may be helpful to you as well - I am not able to recreate your problem because we don't have an example dataset. Hope…
    in How do I use the XML Advanced Connector to return cdata? Comment by Sam_Arigato June 2023
  • Good Morning Liuli, Try this… SUM(CASE WHEN ReleasedDate >= '2023-04-01T00:00:00' THEN New_Col WHEN ReleasedDate < '2023-04-01T00:00:00' THENOld_Col END) The reason your original calculation did not work is because a CASE statement is granular and a SUM statement is aggregate. Using aggregate statements inside granular…
    in aggregate function with case when condition in calculated field Comment by Sam_Arigato June 2023
  • Good Morning Jim, In our experience, we have found that Domo does interfere with that type of ETL loop. You could create a recursive dataflow that would run the last 7 days. The output of your recursive could then go into your partitioned dataflow. The de-duplicating logic would happen in the recursive dataflow. The…
    in Need help mimicking recursion with partitioned datasets Comment by Sam_Arigato June 2023
Default Avatar