Appending Data Capture using Domo Workbench
New Job Creating a new job that will append the data that has changes in the RDBMS since last load. Job setup First do the initial load of the data using the Create New Data source. The two key setup lines in the sql that are very important are: * Where "ReportDate" > '!{lastvalue:ReportDate}!' The Where clause must…