Add Columns If they exist

[Anonymous]

Hi,

1. This is some dummy data I created in excel but my query returns something similar to this kind of scenario 

2. Transform Data > Select Fruit Column > Pivot Column > Values Column (Quantity) > Aggregate Function (Sum).It creates something like this below

3. Now I need to create another column that adds all the quantities related to melons category. For ex sometimes the query may return only Watermelon and Muskmelon and sometimes maybe just Honeydew melon and sometimes maybe Honeydew and Muskmelon. How to create total column by checking if a column exists and then add? However I know for sure the query returns only four fruits related to melons (i.e they are hardcoded)

[Ashish_Mathur]

Hi,

Your first table was in the best structure.  Why have you pivoted the data in the Query Editor?

[Anonymous]

Checking to see if what I am trying to achieve here is clear or not. I can reframe the requirement if it is not clear.

[Ashish_Mathur]

Hi,

I do not know how to solve this question in your revised structure.

[Anonymous]

Hi,

My end user requires it that way.