What recipe should I use?

GSung

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

EliasH

Hi @GSung
,

Could you clarify a bit about what your use case is and what you're trying to achieve here?

GSung

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