Transform all of the text into the other Text , and keep only the text i'd like

[Chanleakna123]

hi , I have around 50K rows which is in different text description in each row there're only 3 different texts in row that i'd like to keep , for the rest , I wanna change those text to "warehouse" . I have no idea how to do this since this is such a lots of rows , 50K rows we can't do it manually one by one right ? for example : *Scrapped to WH *Ready to Market *Ready for Refurbishment *ddfdfdg *ererw *fgfhgf *sdfsdg *Ready to Market *lfkkdjldfgjioer I wanna covert all the text above that I dun need to "Warehouse" Text , Except Scrapped to WH ,Ready to Market ,Ready for Refurbishment , even any other data coming in beside these Scrapped to WH ,Ready to Market ,Ready for Refurbishment it will run to "Warehouse" Text automatically. Thanks with Regards,

[AlB]

Hi @Chanleakna123

Can you show at least a fragment of your table so that it is clear how the data is structured? It'll be much easier fro anyone trying to help. 

[Chanleakna123]

@AlBhi , as aove attached . i have a lots of text as shown . 

which i only need the main text as mentioned , :

*Ready to Market 

*Ready For Refurbishment 

*Scrapped to Cooler 

and then convert all of the different text to "Warehouse" 

thx 

[v-piga-msft · Accepted solution]

Hi @Chanleakna123,

If I understand your requirement correctly that you want to keep the three columns below and convert all of the different text to "Warehouse"?

• Ready to Market 
• Ready For Refurbishment 
• Scrapped to Cooler 

If it is, you could create a conditional column in query editor.

Table.AddColumn(#"Changed Type", "Custom", each if [Description] = "Ready to Market" then "Ready to Market" else if [Description] = "Ready For Refurbishment" then "Ready For Refurbishment" else if [Description] = "Scrapped to Cooler" then "Scrapped to Cooler" else "Warehouse")

Here is the test result.

Best  Regards,

Cherry

[Chanleakna123]

@v-piga-msft you're awesome. 

[v-piga-msft]

Hi @Chanleakna123,

It's glad that we can help you!

Best  Regards,

Cherry

[Chanleakna123]

@v-piga-msftPlease stay beside me 😄 

i still have more to go 😄 hahhahah

[Chanleakna123]

Hi I have only this column. As what mentioned , it has different text in each rows until 50k rows. Can yoy help me to combine the other rest texts into “Warehouse” text name . Excepts the text I mention ? Description Ready to market Ready for refurbishment Ready to Wwarehouse E leng K sona Oun la Raksmey Ready to market Ready to warehouse Ready for refurbishment Quarter &hotpot