Monday, December 31, 2012

Merge tables in IDT

Another new feature of IDT, merging 2 table together, creating a derived table. Of course this is something that can be done by manually. But when there are already joins, objects and filter defined it requires some work. Using the merge tables functionality is much easier, because it takes care of all these changes for you.

Lets say you have these to tables in your universe and want to merge them:

You select both of them, right click and select Merge...

Name the new table...

You will receive a message asking you if you want to delete the original table...

After the merge you only see this 1 table:

When you look at the sql, the tables are joined using the join that existed between the 2 original tables.

1 comment:

  1. Wow, your blogs are always so helpful and really detailed as well. I'm always an avid reader and I can't wait for more. Thanks for the update.