Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to combine multiple rows into one row

I have a report where members have multiple health conditions and risk factors associated with them. Here is an example:

Here the member ID 92919600 has two conditions. This is shown as two rows. I want this rolled up or grouped into one row with all the data (both conditions).

 

I am looking at ROLLUP and GROUPBY as options. There is no data to summarize.

Member IDDiabetesCOPDAsthmaCADHFDepressionCondition Opt Out DiabetesCondition Opt Out COPDCondition Opt Out AsthmaCondition Opt Out CADCondition Opt Out HFMember Engagement LevelMember Engagment Level ReasonMember Engagement Level Date
92918600  Low  NNNNNNLow 2021/03/11 00:00:00
92918600Low    NNNNNNLow 2021/03/11 00:00:00

2 Replies