How to use the Table Insert feature (video) Author: Thomas Lørup Duun Last updated: May 19, 2016 08:07 howto tx2012 video feature table_insert The video below shows you the table insert feature in function. How to use the Table Insert feature Have more questions? Submit a request 5 Comments Date Votes 0 Kurt Denolf October 17, 2012 14:18 In what cases would this be used ? can you give some examples please ? 0 Thomas Lørup Duun October 22, 2012 09:00 The most obvious reason for using the table insert feature is if you want to merge tables on the staging level instead of having to do it on the dwh-level. That way you can avoid adding similar lookups / transformations to multiple staging tables. 0 Thomas Lørup Duun October 23, 2012 07:02 Another usage is if you have a pivoted data source, ie a budget with accounts on rows, months on columns and amount in the cells. Then you could add 12 table inserts, each inserting the account number, the amount and an individual month. 0 Peter Jensen November 22, 2012 14:49 Is it possible to set a filter to define which records should be inserted ? e.g. I have a code definition table (type, code, description) which stores codes and descriptions for several types. I'd like to create a table in the Staging DB for each type in the main table. 0 Thomas Lørup Duun November 26, 2012 15:14 At this point it is not possible to add filters or selection rules on the table insert feature - but I would suggest adding it to the suggestions and feature requests since that would be a nice add-on to the feature! Please sign in to leave a comment.