Log In
Register
Home
February 1, 2019
Offline
Hi Guys,
i have very difficult problem to solve in PQ.
in table AppVersions i have different versions for different Applications including "All" which means that application will work with all versions of system.
In second table i have:
AppVersion (key to left join) and System.
As a result i want to get:
So version 4.1 has joined Linux , other versions have joined "All" and "All" has joined "All" because of exact match.
So if we have Appversion and system for it specified, it will be joined with specified System. In example: 4.1 is joined to 4.1
If we do not have system for AppVersion in Table To Left Join worksheet, it will be mapped to "All" AppVersion. In example: 3.1, 222, 2.5 will be mapped to "All"
If we have "All" as AppVersion it will be mapped to "All" AppVersion in Table To Left Join worksheet. In example: "All" AppVersion in Result table got "Windows" system because Windows is "All" in Table to Left Join worksheet.
Please help,
Jacek
October 5, 2010
Offline
Hi Jacek,
If that is all the data you will be working with you can just use an IF. There are only 2 possible outcomes "Linux" or "Windows" and the only test is if AppVersion is 4.1. If it is then "Linux" else "Windows".
I've also done it in Power Query if you want to go that route.
Regards
Phil
1 Guest(s)
