Forum Discussion

skopcak's avatar
skopcak
Icon for Helper I rankHelper I
9 years ago
Solved

Power Query Editor - occurs in the text character write yes

It is there in the text to find out when it occurs, for example, a character "[" , so that the new row was yes?

 

 

Column 1Column 2 - result
dsagasgasgas]yes
asfasfgasgas yxno
fasfasfasno
asfas]]]]yes

 

Thank you answer

Need Help
  • Sean's avatar
    Sean
    9 years ago

    Hi skopcak

    You can do this very easily using the Query Editor to add a Conditional Column

    Just go to the Add Column tab and click the Condtional Column button...

    Hope this helps! :smileyhappy:

3 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Hi skopcak

    You can do this very easily using the Query Editor to add a Conditional Column

    Just go to the Add Column tab and click the Condtional Column button...

    Hope this helps! :smileyhappy: