cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mojoo91 Frequent Visitor
Frequent Visitor

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:

table1.PNG

Table 2:

Table2.PNG

 

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

2 REPLIES 2
Vitali87 Frequent Visitor
Frequent Visitor

Re: Compare to tables, one with strings and one without

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:

Merge and Compare.jpg

 

mojoo91 Frequent Visitor
Frequent Visitor

Re: Compare to tables, one with strings and one without

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)

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)