STT - Customizing Data with Qlik Replicate

This session addresses: How to Transform Date Fields Source and Target Lookups Table/Field vs Global Transformations Adding Filters to Tasks 00:00 - Intro 01:10 - What does Replicate do? 01:43 - Create a Global Transformation 03:52 - Renaming Tables 04:46 - Review tables in SQL 06:14 - Adding Update Date field 07:52 - Testing Expressions 09:12 - Demo CDC - Updates 09:37 - Adding Table level Insert Date 12:43 - Adding functionality to Snowflake 13:12 - Joining data from two tables 16:45 - Table Level Transformations 18:18 - How to investigate errors 20:08 - Where to find Help documentation 20:44 - Target Lookup Article 21:39 - Source Lookup Article 22:15 - Q&A: SaaS version of Replicate? 22:42 - Q&A: Are complex SQL statements possible? 23:14 - Q&A: Do Qlik Sense and Qlik Replicate work together? 23:27 - Q&A: Can you add Load Time as a column? 24:13 - Q&A: Can you hide sensitive information? 25:00 - Q&A: Where are the Replicate Log Files? 25:36 - Q&A: Which log files help troubleshoot? 26:14 - Q&A: Can you Transform for different sources? 27:22 - Q&A: How to setup Notifications? 28:50 - Q&A: How to transform UTC to local time? 29:23 - Q&A: How to combine First and Last name? 30:05 - Q&A: Are Full Loads necessary with Transformations? For more information: https://community.qlik.com/t5/Knowled... Please rate this video here: https://survey.qlik.com/jfe/form/SV_6...