What recipe should I use?
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 |
Answers
-
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