Hello @everyone, I’ve been facing a challenging data issue recently and would love to get your thoughts and suggestions.
The problem arises when transposing multiselect data in MambaETL, which often leads to tables with an overwhelming number of columns. Since each Encounter Type results in a flat table, and each Encounter Type can have one or more questions with multiselect answers, this creates tables with hundreds of columns. As a result, queries become slower, storage requirements increase, and managing the data becomes more cumbersome.
I’d really appreciate any insights or suggestions you might have on how to tackle this issue! Thanks in advance!