Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@Anonymous ,
In query editor, click merge tables and merge the two tables using fuzzy match.
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 ,
In query editor, click merge tables and merge the two tables using fuzzy match.
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.
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
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |