Atanas Member

Comments

  • You can do it using the "Group By" tile. You will need to group over the whole dataset, i.e. the Group By column will need to be something like the _BATCH_ID, which is usually the same across the full source dataset. The function then of the Group By tile is Minimum, and you applying that function over the column from…
  • A 2 step approach that would work in Magic ETL: 1. Create a "Date Operations" column that will subtract 365 days from the Current Date, call the column something clear like "Current Date minus 365 days" 2. Add a filter component to filter the date field of interest on the "Current Date minus 365 days" column
  • It should be one of the 2 redirect URLs that are listed in the KB article: https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/Microsoft_OneDrive_for_Business_Connector This one worked for me:…