Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chanleakna123
Post Prodigy
Post Prodigy

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

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,
1 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.

 

test result.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
AlB
Super User
Super User

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. 

1.PNG

@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 

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.

 

test result.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-piga-msft you're awesome. 

Hi @Chanleakna123,

 

It's glad that we can help you!Smiley Very Happy

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-piga-msftPlease stay beside me 😄 

i still have more to go 😄 hahhahah

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.