Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Return Multiple values from a string

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

 

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    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.

4 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi Anonymous ,

     

    Try this:-

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

     

    Thanks,

    Samarth

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago
        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

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    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.