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
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
Hi Philip,
thank you!
this is not solving the issue because you can have not onlu Linux and Windows, they can be change dynamically in table (added more).
Can you please advice how to solve?
Jacek
Hi Jacek,
If there's more data to work with then you need to supply it please.
And provide detailed examples of the expected results for this data.
Regards
Phil
