aggregate_work_experiences

preprocess work experience table in datastore to aggregate candidate work experiences on the same position.

INPUT:

datastore // elastic_search

- idUser // id_candidate
- position // position_name
- duration // duration_old
- withinDateString // within_date_new
- withinDate // within_date_old
- createdAt // created_at
- currentlyWorking // currently_working
- idWorkExperience // work_experience_id

OUTPUT:

- id_candidate: unique candidate id // STR
- position_wexp: position for the reported work experience // STR
- wexp_duration_months: summed duration of all work experiences reported by the candidate on position // INT
- wexps_on_position: number of work experiences reported by the candidate // INT
- currently_working: whether the candidate is currently working on a job on position or not // BOOL