What recipe should I use?

GSung
Level 3
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

TypeGain Loss 
A1015
B1220
C5040

 

I am trying to build a new table, using the table above

 $$
XYZ50
ABC20

 

0 Kudos
2 Replies
EliasH
Dataiker

Hi @GSung,

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

0 Kudos
GSung
Level 3
Author

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 ๐Ÿ™‚

 

 

0 Kudos