Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a list of job descriptions scraped from job boards that are varible strings
I also have a list of job skills
What I would like to do is create a column that comtains the words in the skills colmun
I.e
Job Description
'We would like SQL, Power BI, Cognos'
Skills List
SQL
Power BI
Cognos
Alteryx
SAP
What I would like is a column that then returns
NEW COLUMN
SQL, Power BI, Cognos
thanks for any help
Solved! Go to Solution.
Hi, @Anonymous
Try this:
Measure =
COUNTROWS(
CALCULATETABLE(
'Table',
CONTAINSSTRING( 'Table'[JD], MAX( 'Skills Table'[Skill] ) )
)
)
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Try this:
Measure =
COUNTROWS(
CALCULATETABLE(
'Table',
CONTAINSSTRING( 'Table'[JD], MAX( 'Skills Table'[Skill] ) )
)
)
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Try this:-
Column = CONCATENATEX ( VALUES ( 'Table'[Skills List ] ), [Skills List ], "," )
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
thanks for that but what i need is
if the descprition contains a values from the list extract it into another list
i.e
Skills Table
Excel
Oracle
SQL
despription Table
I want Oracle
I want Oracle and SQL
Result
SKILL
Oracle 2
SQL 1
if the description contains any of the words in the skills table extract it and put it in a column
description TABLE |
We need oracle , SQL, Power BI |
Skills Table Oracle SQL Power BI Excel Qlick Alteryx
|
Result
We need oracle , SQL, Power BI = SQL, Power BI , Oracle