Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Add Columns If they exist

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)

 

 

 

4 Replies

  • Hi,

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      My end user requires it that way. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        Ashish_Mathur
        Super User

        Hi,

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