Hi All, I have 2 simple tables T1 has only one column ( P1:A B C D E F G H = 8 rows) & T2 also one column ( P2: a b c d e f g h = 8 rows ). When i join the T1 &T2 (left join ) I am getting no data in the second column but all are blanks .
Question: Can’t we see the data when we join Lower case & upper case letters of same names or product names
Is the issue resolved? I see that you confirmed you are able to view the data.
@Xclipse , yeah but that was after converting letters lower case to upper case.
my Question. Can’t we join lower case & upper case of same names or letters. This is limitation or will it works like that in QS?
For Ex. Pink pink – not able to join & not able to see the data
But: Pink Pink – able to join & able to see the data
Joins are case-sensitive by default. This means that values like “Pink” and “pink” are treated as distinct, which can lead to issues when joining datasets if the case doesn’t match exactly. To ensure successful joins regardless of case differences, you can standardize the case of the join keys in both datasets. This can be achieved by creating calculated fields that convert the join keys to either all uppercase or all lowercase, just as you did.
Please refer to the below documentation this might be helpful for you.
Oohh. Okay. Thanks @Xclipse .
