topic Processing data tables with duplicated values in General
https://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574109#M2180
<P>Hi everybody,</P><P> </P><P>I would ask in here for some ideas because i'm running out of ideas for what i have to accomplish, as it is displayed below:</P><P> </P><P>I have 2 different tables in excel workbooks, im trying to do a VLookUp process to add some information from the table 2 to table 1, for this I´m currently using a Find and Repalce tool. The problem in here is that half of the 15k values are duplicated (sometimes i could find 3 or more times the same value), so do you have any idea of how could i make this find and replace or any other tool works for this?</P><P> </P><P>So basically i need to match date and value and add the information of the color to the first table....</P><P> </P><P>The tables abovementined are kind of like the followings:</P><TABLE><TBODY><TR><TD>TABLE 1</TD><TD> </TD><TD> </TD><TD> </TD><TD>TABLE 2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Concept</TD><TD>Date</TD><TD>Value</TD><TD> </TD><TD>Concept</TD><TD>Date</TD><TD>Color</TD><TD>Value</TD></TR><TR><TD>A</TD><TD>20/05/2020</TD><TD>100</TD><TD> </TD><TD>A</TD><TD>20/05/2020</TD><TD>Red</TD><TD>100</TD></TR><TR><TD>B</TD><TD>20/05/2020</TD><TD>323</TD><TD> </TD><TD>B</TD><TD>20/05/2020</TD><TD>Geen</TD><TD>323</TD></TR><TR><TD>C</TD><TD>20/05/2020</TD><TD>266</TD><TD> </TD><TD>C</TD><TD>20/05/2020</TD><TD>Blue</TD><TD>266</TD></TR><TR><TD>D</TD><TD>20/05/2020</TD><TD>266</TD><TD> </TD><TD>D</TD><TD>20/05/2020</TD><TD>Black</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>20/04/2020</TD><TD>266</TD><TD> </TD><TD>A</TD><TD>20/04/2020</TD><TD>Purple</TD><TD>266</TD></TR><TR><TD>B</TD><TD>20/04/2020</TD><TD>400</TD><TD> </TD><TD>B</TD><TD>20/04/2020</TD><TD>White</TD><TD>400</TD></TR><TR><TD>C</TD><TD>20/04/2020</TD><TD>50</TD><TD> </TD><TD>C</TD><TD>20/04/2020</TD><TD>Yellow</TD><TD>50</TD></TR><TR><TD>D</TD><TD>20/04/2020</TD><TD>323</TD><TD> </TD><TD>D</TD><TD>20/04/2020</TD><TD>Brown</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>A</TD><TD>20/04/2020</TD><TD>Golden</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>B</TD><TD>20/04/2020</TD><TD>Silver</TD><TD>323</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>C</TD><TD>20/03/2020</TD><TD>Violet</TD><TD>323</TD></TR></TBODY></TABLE><P> </P><P>Do you have any idea for avoiding for example, that the third value in table 2 will be the only one that would be added in all the corresponding cases?</P><P> </P><P>Thanks for your support.</P>Wed, 20 May 2020 16:58:57 GMTDiemm2020-05-20T16:58:57ZProcessing data tables with duplicated values
https://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574109#M2180
<P>Hi everybody,</P><P> </P><P>I would ask in here for some ideas because i'm running out of ideas for what i have to accomplish, as it is displayed below:</P><P> </P><P>I have 2 different tables in excel workbooks, im trying to do a VLookUp process to add some information from the table 2 to table 1, for this I´m currently using a Find and Repalce tool. The problem in here is that half of the 15k values are duplicated (sometimes i could find 3 or more times the same value), so do you have any idea of how could i make this find and replace or any other tool works for this?</P><P> </P><P>So basically i need to match date and value and add the information of the color to the first table....</P><P> </P><P>The tables abovementined are kind of like the followings:</P><TABLE><TBODY><TR><TD>TABLE 1</TD><TD> </TD><TD> </TD><TD> </TD><TD>TABLE 2</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Concept</TD><TD>Date</TD><TD>Value</TD><TD> </TD><TD>Concept</TD><TD>Date</TD><TD>Color</TD><TD>Value</TD></TR><TR><TD>A</TD><TD>20/05/2020</TD><TD>100</TD><TD> </TD><TD>A</TD><TD>20/05/2020</TD><TD>Red</TD><TD>100</TD></TR><TR><TD>B</TD><TD>20/05/2020</TD><TD>323</TD><TD> </TD><TD>B</TD><TD>20/05/2020</TD><TD>Geen</TD><TD>323</TD></TR><TR><TD>C</TD><TD>20/05/2020</TD><TD>266</TD><TD> </TD><TD>C</TD><TD>20/05/2020</TD><TD>Blue</TD><TD>266</TD></TR><TR><TD>D</TD><TD>20/05/2020</TD><TD>266</TD><TD> </TD><TD>D</TD><TD>20/05/2020</TD><TD>Black</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>A</TD><TD>20/04/2020</TD><TD>266</TD><TD> </TD><TD>A</TD><TD>20/04/2020</TD><TD>Purple</TD><TD>266</TD></TR><TR><TD>B</TD><TD>20/04/2020</TD><TD>400</TD><TD> </TD><TD>B</TD><TD>20/04/2020</TD><TD>White</TD><TD>400</TD></TR><TR><TD>C</TD><TD>20/04/2020</TD><TD>50</TD><TD> </TD><TD>C</TD><TD>20/04/2020</TD><TD>Yellow</TD><TD>50</TD></TR><TR><TD>D</TD><TD>20/04/2020</TD><TD>323</TD><TD> </TD><TD>D</TD><TD>20/04/2020</TD><TD>Brown</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>A</TD><TD>20/04/2020</TD><TD>Golden</TD><TD>266</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>B</TD><TD>20/04/2020</TD><TD>Silver</TD><TD>323</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>C</TD><TD>20/03/2020</TD><TD>Violet</TD><TD>323</TD></TR></TBODY></TABLE><P> </P><P>Do you have any idea for avoiding for example, that the third value in table 2 will be the only one that would be added in all the corresponding cases?</P><P> </P><P>Thanks for your support.</P>Wed, 20 May 2020 16:58:57 GMThttps://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574109#M2180Diemm2020-05-20T16:58:57ZRe: Processing data tables with duplicated values
https://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574143#M2181
<P><LI-USER uid="71593"></LI-USER> </P><P> </P><P>Could you match on Date, Value and Concept? Then I would recommend a Join tool...if not I have another idea but first let's start with whether you can match by Concept as well.</P><P> </P><P>Thanks,</P><P> </P><P>J</P>Wed, 20 May 2020 17:38:45 GMThttps://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574143#M2181the_jake_tool2020-05-20T17:38:45ZRe: Processing data tables with duplicated values
https://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574158#M2182
<P>I have tried, but sometimes concepts are the same, and the inconvenient in that, was that join was duplicated the number of records.... from 15k to 30k, it was more difficult to know which ones were the original records from table 1, that is the reason for which i´m trying to use Find and Replace tool for adding the field "color" to the original records. </P>Wed, 20 May 2020 17:57:23 GMThttps://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574158#M2182Diemm2020-05-20T17:57:23ZRe: Processing data tables with duplicated values
https://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574164#M2183
<P><LI-USER uid="71593"></LI-USER> </P><P> </P><P>No problem!</P><P>I understand!</P><P> </P><P>Try the attached workflow - I think I solved the issue <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI> </P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.jpg" style="width: 400px;"><img src="https://pvsmt99345.i.lithium.com/t5/image/serverpage/image-id/113979i70B5FACC5DA4E9D3/image-size/medium?v=1.0&px=400" title="image.jpg" alt="image.jpg" /></span></P><P> </P>Wed, 20 May 2020 18:04:29 GMThttps://community.alteryx.com/t5/General/Processing-data-tables-with-duplicated-values/m-p/574164#M2183the_jake_tool2020-05-20T18:04:29Z