Harmonize value of 'map' field

duxbuse / ninthage-data-analytics

A better way for the project to ingest tournament results

GNU General Public License v3.0

1 stars 0 forks source link

Harmonize value of 'map' field #183

Open SanderND opened 1 year ago

SanderND commented 1 year ago

The field 'map' from NewRecruit is filled with 'Map A1'. From Warhall it's 'A1'. Can this be harmonized so that all entries use the same registration? E.g. 'A1'.

SanderND commented 1 year ago

Currently i need this formula to harmonize the values in the 'map' field:

IF ((isnull([Map])=TRUE) or [Map]="OTHER" or [Map]="Custom Map") THEN "No map info" ELSEIF([data_source]="NEW_RECRUIT") THEN SPLIT([Map]," ",2) ELSE [Map] END