Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerQuery case sensitive workaround

Hi,    I'm trying to use a workaround for PowerQuery being case insensitive but had a bit of trouble implementing it. The workaround adds an invisible character next to each lowercase character. ht...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Xue Ding,

     

    I found a workaround by concattening two ID numbers which gave me another UID. 

     

    Thanks

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

I test the code. They work fine in my sample. Can you please share some screenshots? Then we will understand clearly about your problem.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Xue Ding,

     

    I found a workaround by concattening two ID numbers which gave me another UID. 

     

    Thanks

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

      Glad that you have resolved it. Please accept your answer as a solution. Then we will be able to close the thread. More people will benefit here.

       

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.