Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Compare to tables, one with strings and one without

Hello,

I have two tables one with Strings in some cells divided by delimiters " / " and another Table to compare it to without strings.

 

Table 1:

Table 2:

 

The problem I have, is that i don't want to split the first table into new rows by delimiter becuase I get to many variations ( last time i tried over 50 million in my case). Normaly I merge both tables to find the difference between them.

 

Is it possible to compare the rows of the two table without spliting the cells  of the first table into new rows?

 

Best

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This, to me, boils down to comparing strings. And the sub-question to your problem is - do you need an exact match between the tables, or are you happy with partial match. 

    Another thing - can you do a merge of the tables, in a way that you can compare apples to apples (i.e. Car chassis number) - see the example below:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I need to find the exact rows of table 2 which are not present in table 1.

       

      I my example it would be the second row of tabe 2 (car, blue, 200KW, 10)