Is it possible to merge queries by columns where only part of string is the same?
For example:
I have table_1, where in column A I have values:
Mo
We
Fr
and table_2 with values in column A:
Monday
Tuesday
Wednesday
Thursday
Friday
Can I merge these by matching
Mo-Monday
We-Wednesday
Fr-Friday
??
No - but it would be trivial to add a custom column to Table 2, which extracts the first two characters from Column A, then you could join on that column.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks