Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

New column from lookup table

Hi,

I'm trying to create a new column in my data table, based on a fuzzy match text in another table.

I've got two tables:

- Data (Date, Value, Description)

- Lookup (Description_ref, Category, SubCategory

 

So basically, I'm trying to add a new Category column and a SubCategory column into my Data table based on matching the text in the Description column.  The text in the ref table will only be a partial not a full match.

 

What is the best way to:

- create the relationship between the tables?

- lookup values based on the partial matched text?

 

Thanks in advance

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

In query editor, click merge tables and merge the two tables using fuzzy match.

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

In query editor, click merge tables and merge the two tables using fuzzy match.

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Dear @Anonymous 

 

As you mentioned partial match, you can use the query directly in the same.

If you create relationships to the tables it will give you the values which are matched 

 

Regards

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.