Wide & Long data tables harmonization (Long query loses units measure changes, keeping only the last one and merging parameters potentially with different units)
Here the comparison between Wide & Long data tables: whereas the wide query output keeps track of every units measure change on the same parameter, assigning a columns for each unit, the long query assign a unique column for each parameter, without take in account the eventual unit change. Thus, under the same column there could be values collected adopting different units and this is wrong
Is it possible to fix this issue in the long data table?