Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi all,
I am trying to build a new table using an data from an existing table. Can you please advise what kind of recipe should I use?
Existing Table
Type | Gain | Loss |
A | 10 | 15 |
B | 12 | 20 |
C | 50 | 40 |
I am trying to build a new table, using the table above
$$ | |
XYZ | 50 |
ABC | 20 |
Hi @GSung,
Could you clarify a bit about what your use case is and what you're trying to achieve here? 🙂
Hi EliasH,
I am trying to build a new table of data (the 2nd table in my original message) using an existing dataset (the first table in my original message). I was going to use the GROUP recipe initially but I realized in the new table I am trying to create, I am utilizing different columns (from the first table), so I didn't think the GROUP recipe is going to work.
I have colored coded the numbers between the 1st/2nd table, so that you can visualize what I am trying to achieve in my 2nd table
Hope this makes more sense 🙂