# BC Adapter - Merge extension tables option **URL:** \ **Category:** Data Sources Q&A\ **Tags:** migrated\ **Created:** [March 22, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229 "2023-03-22T00:00:00Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![andri](https://community.timextender.com/letter_avatar_proxy/v4/letter/a/a88e4f/32.png) [@andri](https://community.timextender.com/u/andri)\ **Post date:** [March 22, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/1 "2023-03-22T00:00:00Z")
In version 20.10.39 you sneaked in a new features in the BC Adapter data source: - _17627: Business Central adapter - Merge extension tables option for SQL Server provider_ Added option to merge a table and its extension tables together as one table. This feature could be very useful but I can’t find any documentation on how it works and if there are any limits or considerations that need to be taken into account. Initial testing suggest that it works for some tables but maybe not for tables in extension modules? _Originally posted on the Timextender Community (Gainsight), 2023-03-22._ ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [March 22, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/2 "2023-03-22T00:00:00Z")
​Hi Andri I did the testing of this, so I may have some more info about this. It is a feature added to help with the newest BC version 20 release. For the earlier versions it will not be able to find any tables to merge. This version 20 has all the tables split out into multiple tables with a company$tablename$guid setup. Like this ![](https://community.timextender.com/uploads/default/original/2X/b/ba1c5756923adb00b8f8ee0812c8a68178e29652.webp) So the what the merge feature does, is to merge these into one customer table for example. The limits I found was that they were entirely different tables and sometimes the additional ones would make it be not able to be incrementally loaded using the timestamp field. ![](https://community.timextender.com/uploads/default/original/2X/c/c6e30a42697ba3c8199ebaac6bb326e4420b733d.webp) You can see the generated query if you open the query tool of the table. ![](https://community.timextender.com/uploads/default/original/2X/0/0815a1bff46a096b2988782f2eb412ecefd9c1ee.webp) If you turn off the merge, it will not do so, but the main table will not be named tablename$guid when you select it. That is pretty much all there is about this. Also, if you want to try this I can send the demo version I used to you? ---
**Author:** ![Christian\_Hauggaard](https://community.timextender.com/letter_avatar_proxy/v4/letter/c/ba8739/32.png) [@Christian\_Hauggaard](https://community.timextender.com/u/Christian_Hauggaard)\ **Post date:** [March 29, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/3 "2023-03-29T00:00:00Z")
@andri does Thomas’ answer above help clarify the merge functionality? If so could you please help us by marking the best answer above. Please let us know if you have any follow up questions :) ---
**Author:** ![andri](https://community.timextender.com/letter_avatar_proxy/v4/letter/a/a88e4f/32.png) [@andri](https://community.timextender.com/u/andri)\ **Post date:** [April 21, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/4 "2023-04-21T00:00:00Z")
Thanks, Thomas for giving some description about this feature. One thing that we are seeing is that fields from extension tables related to “non-standard” BC tables from external modules do not get added to the primary “non-standard” tables. In these cases the extension tables are removed, the guid part of the primary tables are removed from the name but the extension fields do not get added to the primary tables. Is this a bug, is there a workaround or does this feature only work with extensions to standard BC tables, like Customer, Item etc. ? ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [April 21, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/5 "2023-04-21T00:00:00Z")
Hi Andri Do you use the SIFT option as well? ![](https://community.timextender.com/uploads/default/original/2X/e/e8bb3851ddfd1d2b5318dde9d0d1555d9e17c688.webp) Then maybe it is an issue. ---
**Author:** ![andri](https://community.timextender.com/letter_avatar_proxy/v4/letter/a/a88e4f/32.png) [@andri](https://community.timextender.com/u/andri)\ **Post date:** [April 26, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/6 "2023-04-26T00:00:00Z")
Hi Thomas A change to the SIFT option does not seem to make a difference for this issue. ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [April 26, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/7 "2023-04-26T00:00:00Z")
Hi Andri Can you still locate these tables as extra tables, or do they not exist in the selection area? ---
**Author:** ![andri](https://community.timextender.com/letter_avatar_proxy/v4/letter/a/a88e4f/32.png) [@andri](https://community.timextender.com/u/andri)\ **Post date:** [April 26, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/8 "2023-04-26T00:00:00Z")
The main tables from the external module are available but they do not include any new fields. The guid post-fix is removed from the name and their related extension tables are not shown in the selection area. ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [April 26, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/9 "2023-04-26T00:00:00Z")
If you turn off the merge, so the tables again gets split up, does they appear? My whole point is to work out what works and what does not to see if there is something to pass on to the developers. ---
**Author:** ![andri](https://community.timextender.com/letter_avatar_proxy/v4/letter/a/a88e4f/32.png) [@andri](https://community.timextender.com/u/andri)\ **Post date:** [April 26, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/10 "2023-04-26T00:00:00Z")
Yes, if the merge feature is turned off, the extension tables appear again. ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [April 27, 2023, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/11 "2023-04-27T00:00:00Z")
So for a workaround, you could create two data sources based on the same BC provider. Then one merges the tables and the other do not. You then add these extension tables to the main ones in the DSA or DWH. I don’t know if I can replicate it myself, as I only have an exported test database, but I will ask if this is seen as a bug or a feature. ---
**Author:** ![ted.clark](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/4491bb/32.png) [@ted.clark](https://community.timextender.com/u/ted.clark)\ **Post date:** [February 27, 2024, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/12 "2024-02-27T00:00:00Z")
Is there a version of BC that manages the $ext tables in BC seamlessly now? I have merge option connection that gets data in the core table, but extension table columns do not come in and only the one named table is available.  ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [February 28, 2024, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/13 "2024-02-28T00:00:00Z")
Hi @ted.clark  It is supposed to merge all these extensions together and generate one table with the name. If you turn off the merge option, do you then see multiple versions following the setup explained with a guid on the end of it? ---
**Author:** ![ted.clark](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/4491bb/32.png) [@ted.clark](https://community.timextender.com/u/ted.clark)\ **Post date:** [February 29, 2024, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/14 "2024-02-29T00:00:00Z")
@Thomas\_Lind working through the workaround here and finding that incremental on the $ext part is not a given as there is no modified date kind of column to rely on. I am not sure if you question from 10 months ago every pointed this as a bug or feature, but would like to see it fast-tracked nonetheless. Working with a project where the BC instance has 20+ entities with $ext portions so this workaround on repeat and then individually managing incrementals and joins within the solution is a bit of a big pill to swallow. Thanks for quick reply.  ---
**Author:** ![Thomas\_Lind](https://community.timextender.com/letter_avatar_proxy/v4/letter/t/a88e4f/32.png) [@Thomas\_Lind](https://community.timextender.com/u/Thomas_Lind)\ **Post date:** [February 29, 2024, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/15 "2024-02-29T00:00:00Z")
Hi @ted.clark  Yeah, incremental load can be a bit difficult when the extension tables aren’t containing the necessary fields for it as well. ---
**Author:** ![Christian\_Hauggaard](https://community.timextender.com/letter_avatar_proxy/v4/letter/c/ba8739/32.png) [@Christian\_Hauggaard](https://community.timextender.com/u/Christian_Hauggaard)\ **Post date:** [November 13, 2024, 12:00am UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/16 "2024-11-13T00:00:00Z")
@ted.clark @andri a fix for the extension tables has been released in 20.10.54. Please see following item in release notes for reference: [https://legacysupport.timextender.com/hc/en-us/articles/360051186931-Release-Notes-for-TimeXtender-20-10-x](https://legacysupport.timextender.com/hc/en-us/articles/360051186931-Release-Notes-for-TimeXtender-20-10-x) _22218: Business Central adapter not reading extension tables with $ext added to them_ Resolved issue with Business Central adapter not reading extension tables containing '$ext' suffix.  ---
**Author:** ![westdorp](https://community.timextender.com/user_avatar/community.timextender.com/westdorp/32/3597_2.png) [@westdorp](https://community.timextender.com/u/westdorp)\ **Post date:** [November 6, 2026, 2:41pm UTC](https://community.timextender.com/t/bc-adapter-merge-extension-tables-option/1229/17 "2026-11-06T14:41:36Z")
Hi, Is this ‘Merge Extension tables’ available in TDI or only in Classic? Regards, Dirk