Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to filter an inventory tabel from my Dynamics C5 but the Location colum on my primary location is marked with an ASCII code (┐) in the SQL db. Does anyone knows how I can use this as a filter? PS: It dosn't work just trying it in 😉 BR Morten
Hi @Lautorp,
How do you want to use it exactly? I can do it this way in a slicer.
Best Regards!
Dale
In my Inventory table in my Dynamics C5, my warehouse location is set with a blank character in the C5 system, but in the SQL table an ASCII character (CHAR(2)) is set.
I want to filter my inventory record so I only see my blank location.
Hope that makes sence 😉
Morten
Hi @Lautorp,
Can you connect to the SQL directly?
Best Regards,
Dale
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |