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 skill...
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.

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