cancel
Showing results for 
Search instead for 
Did you mean: 

Data Modeling Uppercase and Lowercase issues

Hello,

 

I was also having the same issue but got the solution after some effort.

You can try converting your string into ASCII code into the query editor using M query.

Create a custom column in the query editor and convert your string letter by letter into relevant ASCII Code.

For example, a Column having the string = Product ID 

 

 Text.From(Character.ToNumber(Text.Middle([#"Product ID"],0,1))) &"|"&

Text.From(Character.ToNumber(Text.Middle([#"Product ID"],1,1))) &"|"&
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],2,1)))&"|"&
Text.From(Character.ToNumber(Text.Middle([#"Product ID"],3,1)))

 

You will get ASCII code for your String separated by "|" letter by letter.

 

Now after loading in the BI table, Split the ASCII code by "|", and using UNICHAR  decode the ASCII Code.

The method is a little typical but you will get the result.

 

Status: New
Comments
v-yingjl
Community Support

Hi @Harsh1708 ,

Thanks for your sharing and it would help others in the community.

 

Best Regards,
Community Support Team _ Yingjie Li