# Adding data to build datatable issue **URL:** \ **Category:** Activities\ **Tags:** datatable, question, studio, excel, system, activities\ **Created:** [21.Ноябрь.2023 06:02:42 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204 "2023-11-21T06:02:42Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 06:02:42 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/1 "2023-11-21T06:02:42Z")
Hi everyone, I’m facing an issue in updating extracted data from webpage to build datatable activity. I’m using build datatable to add my headers. I’m extracting data from LinkedIn. sometimes I may not having some fields and it’s having null. When i try to update this data build datatable. It is writing in wrong columns. ![17005464421426002593165723233272](https://global.discourse-cdn.com/uipath/original/4X/3/d/4/3d4cca774e838f28bf551ef8738fc9eb4c5c448c.jpeg) For this data I don’t have salary in LinkedIn. When i try to update that in Excel it’s giving 1 column wrongly. In mentioned picture it’s writing reposted value in SALARY column. How can I fix this. ![17005464776728847269213367400563](https://global.discourse-cdn.com/uipath/original/4X/1/9/c/19cc4566895974985fe3f4b6544836f6481390aa.jpeg) ---
**Author:** ![Shiva\_Nikhil](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shiva_nikhil/32/267408_2.png) [@Shiva\_Nikhil](https://forum.uipath.com/u/Shiva_Nikhil)\ **Post date:** [21.Ноябрь.2023 06:06:05 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/2 "2023-11-21T06:06:05Z")
@Learner007 can you once check whether you are passing all the variables/arguments in the add datarow activity if the values is null or not you need to pass that variables in the add data row activity,accordingly to the columns names can you share the image of add data row activity the way you have passed ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 06:12:40 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/3 "2023-11-21T06:12:40Z")
Hi @Shiva_Nikhil I’m not using add datarow activity here. I’m extracting data from website and storing in “Extractdatatable” variable. For this datatable I need to add a new column in starting I’m adding that using add data column activity. After that I’m directly appending that data to my excel. ![1700547095327366179082060433154](https://global.discourse-cdn.com/uipath/original/4X/a/f/a/afaca6e55dbfcfa048b529499a8cd9bf4c87c77a.jpeg) ![17005471192553733597477866681040](https://global.discourse-cdn.com/uipath/original/4X/4/c/8/4c815ac3805c93a5930d8622f7834b59b79886e6.jpeg) ![17005471392685129067571972955825](https://global.discourse-cdn.com/uipath/original/4X/1/8/4/18476474dd016b71e846cdde21ff94ae208ac581.jpeg) ---
**Author:** ![Shiva\_Nikhil](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shiva_nikhil/32/267408_2.png) [@Shiva\_Nikhil](https://forum.uipath.com/u/Shiva_Nikhil)\ **Post date:** [21.Ноябрь.2023 06:17:48 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/4 "2023-11-21T06:17:48Z")
@Learner007 check whether the data you have extracted is having the same columns are not if you are having headers just want to add data to appropriate columns means you can try with merge data table activity and below that use write range activity ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 06:18:50 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/5 "2023-11-21T06:18:50Z")
@Shiva_Nikhil ok, let me try that ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 06:27:00 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/6 "2023-11-21T06:27:00Z")
@Shiva_Nikhil i tried that. It’s not getting the column. While extracting data from web. If the data is not available for that column, it’s skipping that column. In between Location and Reposted there is another column called salary. It’s missed because there is no salary for those records in website. ![17005479324193344886681964436465](https://global.discourse-cdn.com/uipath/original/4X/0/8/d/08db1e12bbfff8a5b715539cf99f503f5aacb9f9.jpeg) ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 07:18:18 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/7 "2023-11-21T07:18:18Z")
@Yoichi , @Anil_G any help on this ---
**Author:** ![Yoichi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yoichi/32/523754_2.png) [@Yoichi](https://forum.uipath.com/u/Yoichi)\ **Post date:** [21.Ноябрь.2023 07:37:29 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/8 "2023-11-21T07:37:29Z")
HI, Can you try as the following? First create empty datatable using BuildDataTable (Let’s say dtResult) Next use MergeDataTable : src is ExtractDataTable, dist is dtResult Finally use Append range. ![image](https://global.discourse-cdn.com/uipath/original/4X/c/1/2/c12bfb22a8279eb6965387c4fe123babc2d2bdb0.png) Regards, ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 07:43:46 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/9 "2023-11-21T07:43:46Z")
Hi @Yoichi getting below error. Actually I have some more additional columns in my Build datatable and which are not available in extracted datatable. I need to go to another website to fill rest of the columns ![17005526033732193364334613270790](https://global.discourse-cdn.com/uipath/original/4X/b/d/3/bd3a37e2a33bc45d6b9c502f61431cd892f6bb5e.jpeg) ---
**Author:** ![Yoichi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yoichi/32/523754_2.png) [@Yoichi](https://forum.uipath.com/u/Yoichi)\ **Post date:** [21.Ноябрь.2023 07:45:25 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/10 "2023-11-21T07:45:25Z")
Hi, Can you check datatype of “JobTitle” in AddDataColumn activity? Probably it should be String type. Regards, ---
**Author:** ![Learner007](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/learner007/32/276338_2.png) [@Learner007](https://forum.uipath.com/u/Learner007)\ **Post date:** [21.Ноябрь.2023 08:00:03 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/11 "2023-11-21T08:00:03Z")
Thanks @Yoichi it worked ---
**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\ **Post date:** [24.Ноябрь.2023 08:00:32 UTC](https://forum.uipath.com/t/adding-data-to-build-datatable-issue/701204/12 "2023-11-24T08:00:32Z")
Закрыл(а) тему 24.Ноябрь.2023 08:00:32 UTC This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.