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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
stephaniesmall
Regular Visitor

Power Bi & R Script Problem with Stringr displacing columns unintentionally

I built an r script using stringr that should build 2 columns, Salesforce & CRM1. It is performing as expected except for in some rows, it is moving & deleting data from cells that are not being called in the following code: 

 

library(stringr)

SFDC <- c("SFDC|Salesforce")

Dynamics <- c("Dynamics|Microsoft|365")

Oracle <-c("Oracle|On Demand|Ondemand")

SAP <- c("SAP|Siebel")

InHouse <- c("in house|internal|inhouse|proprietary")

Unknown <- c("don't know|unknown|not sure|not mention|can't remember")

None <- c("none|no crm|N/A")

dataset$salesforce <- str_replace_all(

  str_replace_all(

  str_replace_all(

  str_replace_all(

  str_replace_all(

  str_replace_all(

  str_replace_all(dataset$new_crmused, regex(SFDC, ignore_case=TRUE), "Salesforce"),

      regex(Dynamics, ignore_case=TRUE), "Dynamics"),

      regex(Oracle, ignore_case=TRUE), "Oracle"),

      regex(SAP, ignore_case=TRUE), "SAP Siebel"),

      regex(InHouse, ignore_case = TRUE), "In House System"),

      regex(Unknown, ignore_case = TRUE), "Unknown"),

      regex(None, ignore_case=TRUE), "None")

dataset$CRM1 <- str_extract(dataset$salesforce,"Salesforce|Dynamics|Oracle|SAP Siebel|In House System|Unknown|None")

 

Does anyone have any ideas why it is doing this?

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @stephaniesmall 

I'm not the expert of R, please check if it works as expected on R side, if not, you could ask questions in R forums.

 

Best Regards
Maggie

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.