Forum Discussion

ak77's avatar
ak77
Post Patron
2 years ago

Table data in UPPER case

Hi Gurus,

 

need a help if anyone came across this case.please check.

 

i have a table with huge dataset and  columns called O_Asset Class, portfolio override coming from a sql table. i have a switch statment which has a logic 

All the cases are working fine, but in one case. the data is getting to UPPER case(TOTAL INFRASTRUCTURE . Does anyone have any idea why this UPPER case is happening? 

These 2 columns are from DB 

 

 

 

 

Below is the Switch statment result:

Switch Asset/Sub-Class Benchmark = SWITCH (
    TRUE,
 
 (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Benchmark")) && (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Excess"))) && LEN(Client_Returns_Data[Portfolio_Node_Name_Override])=0),Client_Returns_Data[O_Asset/Sub-Class Benchmark], (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Benchmark")) && (NOT(CONTAINSSTRING(Client_Returns_Data[O_Asset/Sub-Class Benchmark],"Excess"))) && LEN(Client_Returns_Data[Portfolio_Node_Name_Override])>0),Client_Returns_Data[Portfolio_Node_Name_Override],
 Client_Returns_Data[O_Asset/Sub-Class Benchmark]
)

 

 

 

Sounds really wierd

 

Show and Tell
Tips and Tricks

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    ak77 weird, can you double check if there are two values from DB, one with Upper case?

    • ak77's avatar
      ak77
      Post Patron
      2 years ago

      parry2k , Yup checked. whole dataset does nt have this upper case in DB

    • ak77's avatar
      ak77
      Post Patron
      2 years ago

      parry2k .Thanks for reply..i had checked it.. verified again now.. there is no translation in PQ.. and in the table view u can see what exactly is coming from DB after power query execution and its normal case 

       

  • ak77's avatar
    ak77
    Post Patron
    2 years ago

    parry2k , Apologies for getting back bit late and yes there is one value with TOTAL INFRASTRUCTURE in upper case in the data set which was lately found during analysis. so is there a way to retain these cases for a particular column