CONCAT(
isNull(concept_hierarchy.level4_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level3_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level2_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level2_concept_name, 'NA'), '||', <---- should be level1_concept_name
isNull(concept_hierarchy.concept_name, 'NA')
) AS concept_path,
Just reading some code and I'm pretty sure that
level2_concept_nameis duplicated insrc/main/resources/resources/cdmresults/sql/report/condition/treemap.sql. The second one should belevel1_concept_namelike insrc/main/resources/resources/cdmresults/sql/report/conditionera/treemap.sql