[Solved] SQL, SUM + CASE [closed]

Never use commas in the FROM clause. Always use proper, explicit JOIN syntax. Then, you cannot nest aggregation functions, so this should be sufficient: SELECT o.ID_DOSSIER, SUM(CASE WHEN ID_TYPE IN (‘0’, ‘1’) THEN TTL * -1 WHEN ID_TYPE IN (‘2’, ‘3’) THEN TTL END) FROM ope o JOIN actor a ON o.ID_ACTION = a.ID_ACTION GROUP … Read more

[Solved] Javascript : Sum into array

Here is an object version. This is not really what you’re after, but along the same lines and honestly, a bit neater as it’s a data structure. var myArray = [ “Apple: 10”, “Apple: 3”, “Banana: 3”, “Pear: 7”, “Pineapple: 7” ]; var newArray = {}; myArray.forEach(function(val) { var item = val.split(“:”); var key = … Read more

[Solved] Change PHP code to JS

I echo the comment above. I believe StackOverflow is not a code writing service unless something changed very recently. However, let’s look at the code you posted. I think it would help to refactor this code into a more logical sense before attempting this in Javascript. That should make it easier to transpose. Every time … Read more

[Solved] Create python dictionary from TXT file – value aggregation

No need to bother with pandas. Text files are iterable. Just open it, operate on the line (string) and fill a dictionnary. file = “font.txt” with open(file, “r”) as f: dic = dict() for line in f: x = line.strip(“\n”).split(” “) key = int(x[0].strip(“px”)) value = int(x[1]) if key not in dic.keys(): dic[key] = [value] … Read more