https://community.databricks.com/t5/get-started-discussions/update-values-in-dataframe-with-values-from-another-dataframe/m-p/43759#M940 <P>Hi, I have to data sources: "admin table" which contains active and inactive employees and I have "hr table" which contains only active employees.</P><P>I need to update admin table with data from hr table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 560px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3513iB0FB6AA0DB03FBC6/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>You can see that I need to update employee with number 153, so manager should be update from David to Laura.</P><P>I use method update(), but I get error&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3514iB545049FE5B44CB4/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>How can I solve the problem?</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 06 Sep 2023 08:43:41 GMT AleksandraFrolo 2023-09-06T08:43:41Z https://community.databricks.com/t5/get-started-discussions/update-values-in-dataframe-with-values-from-another-dataframe/m-p/43759#M940 <P>Hi, I have to data sources: "admin table" which contains active and inactive employees and I have "hr table" which contains only active employees.</P><P>I need to update admin table with data from hr table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 560px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3513iB0FB6AA0DB03FBC6/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>You can see that I need to update employee with number 153, so manager should be update from David to Laura.</P><P>I use method update(), but I get error&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3514iB545049FE5B44CB4/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>How can I solve the problem?</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 06 Sep 2023 08:43:41 GMT https://community.databricks.com/t5/get-started-discussions/update-values-in-dataframe-with-values-from-another-dataframe/m-p/43759#M940 AleksandraFrolo 2023-09-06T08:43:41Z