Forum Discussion
use case sensitive to create a correct relationsship
Hi BI-Desktop experts,
i want to creat a relationsship between two tables. The problem is the programm says there are a duplicate in the table. Thats wrong! There are ID's in the colum: 'vQCZd01OIaAs0EC0001' and 'VQCZd01OIaAs0EC0001' these are diffent datarows. How can i aktivate a case sensitive?
let
Quelle = Oracle.Database("egecko", [HierarchicalNavigation=true]),
PM = Quelle{[Schema="PM"]}[Data],
FIBU_BELEG1 = PM{[Name="FIBU_BELEG"]}[Data],
#"Gefilterte Zeilen1" = Table.SelectRows(FIBU_BELEG1, each [ORGUNIT_NR] = 940)
in
#"Gefilterte Zeilen1"4 Replies
HI Mitschl1986,
Based on test, current relationship seems not case sensitive, you can refer to below link to know more about this:
Create a Dimension Table with Power Query: Avoid the case sensitivity bug!
Creating Case Sensitive Table Relationships
Regards,
Xiaoxin Sheng
Dear Mitschl1986,
In your table FIBU_BELEG, create new Column: "X_FIBU_BELEG_ID" = UPPER('FIBU_BELEG'[FIBU_BELEG_ID])
Then you can create new same formular the other table.
Go to Relationship, edit and change join between 2 table with new X_FIBU_BELEG_ID.
Regards,
ManNVSM.
<pre><span class="">This solution will cause data loss because identifiers must be case sensitive. I have the same problem, still no solution.</span></pre>
You can solve this in Power Query, which is case sensitive. Basically you need to group by name and add an index column which will serve as the ID and which you can then use to create the relationship.
Here is the way to do this:
Sample file attached
