- adding a column to a table,
- adding default values,
- importing a csv,
- field mapping
- creating a Full Join with conditions,
- coalesce, string concatenation.
In this vid, Iama was trying to join 2 reasonably similar tables: a contact table with data pulled from a web contact form + a customer table with more/different columns. I toyed with doing a Union, but decided a Full Join would be a bit easier. Creating these vids and battling with Adobe Captivate 6 is a bit time consuming. This one took two, full days.