Forum Discussion

Lmendes's avatar
Lmendes
Frequent Visitor
8 years ago
Solved

Delimiter at each instance of an integer

Hi I have some concatenated data i.e. 1=Married 2=Single 3=In a sexual relationship 4=Widowed 5=Divorced / Separated 6= Cohabiting   I want to split out into seperate columns. I want to spl...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Lmendes,

     

    You can refer to below sample to transform QA table in query editor and use dax formula to lookup related answers.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lmendes couldn't you split it by the "=" in there? also if the numbers are not needed replace them all by blank or some other character

  • Lmendes's avatar
    Lmendes
    Frequent Visitor
    8 years ago

    thank you for the quick response! Unfortunately I do need the number as I will split out the numbers and use them as a score

     

    Luara