Hi all,
I need to know in a table if this is the first time the application is deployed.
Algorithm is as follow :
- get all applications (from csv file),
- for each application, get the application deployment informations (application details, deployment environnement, deployment date, version deployed, one HTTP call per application, 200+ applications....)
- determine if this is the first time the application is deployed with this version on the environment.
In order to determine if this is the first time, the solution I found is to sort all lines by application name, environment, version, and deployment date, and the compare current line with previous line to check if this is the same version, environment and application. If yes, insert in a new column the previous version, if no, insert "first".
The solution I found to compare from previous line is to user outer join, as described in this site (in French, sorry ;)) : Trucs et astuces - PowerQuery - Archétypes synergies (excel-formations.fr)
- sort lines as described previously,
- add to indexes,
- insert in a new column an outer join (= Table.NestedJoin(#"Index ajouté", {"Index"}, #"Index ajouté", {"Index.1"}, "Index ajouté", JoinKind.LeftOuter))
- then compare the values to determine if this the first time the version is deployed.
Problem is : result is very slow. I can see that for every line, when the compare is done from the outer join, a new HTTP call is done. I tried to use a buffer in different steps, but result is the same : the query is incredibly slow.
Questions are :
- would you have a better solution to compare the lines, and determine if the version is deployed for the first time?
- or would you have a solution to prevent a new HTTP call every time?
Thanks for your help 😉
