cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Pivot Data from rows to columns with many possible values for pivot field

vaidyarm
Contributor

Convert this

accountId region reporttype count
1 APAC L1 Feedback Report 2
1 APAC L2 Feedback Report 2
2 APAC L1 Feedback Report 6
2 APAC L2 Feedback Report 4
3 APAC L1 Feedback Report 17
3 APAC L2 Feedback Report 4
3 EU L3 Feedback Report 3

to below one

accountId Region L1 Feedback Report L2 Feedback Report L3 Feedback Report
1 APAC 2 2 0
2 APAC 6 4 0
3 APAC 17 4 0
3 EU 0 0 3

Note : the report type can have many values so donโ€™t need static way of mapping fields
unique key here is accountid and region

4 REPLIES 4

AleksandarAngel
Contributor III

Hi @vaidyarm,

You can try to achieve that the way I did in the below pipeline. Please note that this might not be the most optimal way achieving whatโ€™s needed.

โ€“sl-comm-pivot-rows-to-columns_2023_04_11.slp (14.5 KB)

BR,
Aleksandar.

That worked perfectly

Thanks a Lot @AleksandarAngelevski ๐Ÿ˜€

Not able to download the slp file, is this broken as part of new community page migration?

dmiller
Admin Admin
Admin

Weโ€™re finding issues with some of the links and have an open issue with our vendor.


Diane Miller
Community Manager