cclee 0 Posted January 8, 2013 Report Share Posted January 8, 2013 Hello uBot community, Been having a blast learning how to use uBot. Have a question on merging 2 tables... What's the easiest way to accomplish the following? (Can I use $Subtract Lists with tables somehow?) Let's say I have 2 tables.Both tables have 2 columns: Fruits, Number -- Table A:Apples, 3Guavas, 10Kiwis, 4 -- Table B:Plums, 18Kiwis, 6Durians, 18 --- I'd like to add the rows from Table A to Table B, only if the fruit doesn't exist in Table B. So for example, the combined result would look like this: New Table C:Apples, 3Guavas, 10Plums, 18Kiwis, 6Durians, 18 I think I can figure this out using loops...But what's the fastest way to accomplish this?(If it weren't a table, I'd just use the Compare and Subtract List functions... ) Thanks for your help! Quote Link to post Share on other sites
mk21 1 Posted January 9, 2013 Report Share Posted January 9, 2013 Save both tables to file as .csv. Add both as add list to list (list from file). Save list as .csv file. Table from file. Quote Link to post Share on other sites
cclee 0 Posted January 12, 2013 Author Report Share Posted January 12, 2013 Save both tables to file as .csv. Add both as add list to list (list from file). Save list as .csv file. Table from file.Hi,Thanks for the response! Unfortunately, doesn't work to simply add the 2 tables together in this case. In Table A, there's: Kiwis, 4.In Table B, there's: Kiwis, 6. Because Kiwis exist in Table B, the "Kiwis, 4" from Table A shouldn't be added.This is the part I'm trying to solve. Appreciate your help! Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.