Giacomo Member

Comments

  • If you were to set up your dataflows as recursive dataflows then I suspect you might be able to do what you're looking for. I'm thinking you can take your existing workflow and add a branch out to a filter whose value is always false like 1=0 and then you'd output to your input dataset recursively. So that upon completion…
    in Deleteing intermediary Dataset values after final OutputDataset Comment by Giacomo May 2021
  • Hello - can you provide any additional information on this? Like, for example, what was the purpose of describing the first table? I'm having trouble understanding how it's used in the final result. Also, how are the periods of interest in your expected dataset stored? and why are they sometimes ranges of dates and other…
    in Stock Open Opportunities by Active Account Executives in a period Comment by Giacomo May 2021
  • Hello - I don't have experience with those particular API's but I have used the Domo No Code JSON connector as well as done some custom connector development and I have to say, Domo makes it so easy to bring in data using these tools. Another option we have used for more complicated connections is worked with Domo to have…
    in Tripadvisor, Google My Business, Trustpilot etc Comment by Giacomo May 2021
  • I think you're looking to use a Windowing function within a Beast Mode, however I do not believe that you can do a count distinct within a Windowing function ( I could be wrong on that). If it's an option you may want to consider doing it within a Magic ETL using the Rank & Window tile.
    in Count No of Records Based on unique ID Comment by Giacomo April 2021
Default Avatar