cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 71 members 1,306 guests
Please welcome our newest community members: