Return Multiple values from a string

[Anonymous]

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

[v-angzheng-msft · Accepted 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.

[Samarth_18]

Hi @Anonymous ,

Try this:-

Column = CONCATENATEX ( VALUES ( 'Table'[Skills List ] ), [Skills List ], "," )

Thanks,

Samarth

[Anonymous]

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

[Anonymous]

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