topic Solution for data comparision in Developer https://community.fabric.microsoft.com/t5/Developer/Solution-for-data-comparision/m-p/3361795#M43706 <P>Hello all,&nbsp;</P><P>I need to find a solution for below issue:</P><UL><LI>We are having 2 tables, in the first table there are 3 attributes (Hostname, Key, Value) and in the second table there are 4 attributes (Hostname, Date, Key, Value)</LI><LI>We are merging the above two mentioned tables keeping <STRONG>Key</STRONG> as a primary key.</LI><LI>And then, we are comparing <STRONG>Value</STRONG>&nbsp;attributes of both tables that they are the same or not.</LI><LI>In the first table, we are getting in one row&nbsp;<STRONG>Value</STRONG> attributes Like { <STRONG>Apple,mango</STRONG> }, and in the second table, we are getting <STRONG>Value</STRONG> attributes like { Apple } or { mango }.</LI><LI>We are comparing <STRONG>Value</STRONG> attributes on the bases of, if one value is the same for both tables then we consider that they are same.</LI></UL><P>&nbsp;</P> Wed, 02 Aug 2023 13:21:00 GMT ankitchauhan26 2023-08-02T13:21:00Z Solution for data comparision https://community.fabric.microsoft.com/t5/Developer/Solution-for-data-comparision/m-p/3361795#M43706 <P>Hello all,&nbsp;</P><P>I need to find a solution for below issue:</P><UL><LI>We are having 2 tables, in the first table there are 3 attributes (Hostname, Key, Value) and in the second table there are 4 attributes (Hostname, Date, Key, Value)</LI><LI>We are merging the above two mentioned tables keeping <STRONG>Key</STRONG> as a primary key.</LI><LI>And then, we are comparing <STRONG>Value</STRONG>&nbsp;attributes of both tables that they are the same or not.</LI><LI>In the first table, we are getting in one row&nbsp;<STRONG>Value</STRONG> attributes Like { <STRONG>Apple,mango</STRONG> }, and in the second table, we are getting <STRONG>Value</STRONG> attributes like { Apple } or { mango }.</LI><LI>We are comparing <STRONG>Value</STRONG> attributes on the bases of, if one value is the same for both tables then we consider that they are same.</LI></UL><P>&nbsp;</P> Wed, 02 Aug 2023 13:21:00 GMT https://community.fabric.microsoft.com/t5/Developer/Solution-for-data-comparision/m-p/3361795#M43706 ankitchauhan26 2023-08-02T13:21:00Z