Forum Discussion
Solved
Pivot Challenge
I'm hoping someone can steer me in the right direction. I have a table with a list of employees and and calculated benefits for their weekly check. I need to be able to upload this data but I'm not...
Hi AskGenie ,
My apology for not paying enough attention.
Starting point: (Based on the file I attached earlier) Step: Changed Type
We need two steps to achieve the outcome:
Step1: GroupBy
Once the GroupBy step generated, go to the formula bar replace the highlighted code below (Image A) with highlighted in Image B.
Image A
Image B
The next step is add a custom column with code below:
The final step is to combine all the tables by adding a custom step (blue circle below) and add the highlighted code:
Regards
KT
Hi AskGenie ,
There are a few ways to achieve the outcome.
One of the way is:
- Unpivot all the columns that forming the two column you want (i.e. PEN, $$ COP $$ etc),
- add index column,
- perform a lookup function with the help of the index column to get the previous row for the value or the name (i.e. PEN / COP), and this will set the benefits and it value next to each other,
- filter out the unnecessary rows.
Regards
KT