Alex DuplerSigh. Some days you just gotta love #powerquery. Today is not one of those days.
Data Pirate@alexdupler case sensitivity showing its true nature again?
@shiprekt ooo. That's a good idea. I don't know how Salesforce handles capitalization.
Wyn -Excel & Power BI@alexdupler @shiprekt yeah, Trim, Uppercase, cross fingers
@alexdupler for me, it's about a 50/50 split between trim/clean or case.
PQ and PBI joins aren't quite in sync with logic - but does tend to highlight untested issues upstream
PQ and PBI joins aren't quite in sync with logic - but does tend to highlight untested issues upstream