Forum Discussion

New Contributor

6 years ago

Solved

Extend columns into Rows without using Copy Snap

Hi everyone,
I am stuck in one transformation I have one student_id which have different marks with subjects and I want to divide it in rows without using copy snap. PFA
The records are coming in this format

And I want to manipulate this records in This way for each ID

I am also attaching the pipeline on which I have worked but I am searching for using less snap and without copy snap
Copy Pipeline_2020_07_08.slp (12.3 KB)

Thanks in advance

Copy Pipeline_2020_07_08.slp12 KB

ptaylor
6 years ago
Wow, can’t believe it took me this long to learn of the Pivot snap. 🙂

Yes, that works nicely for this:

5 Replies

ptaylor
Employee
6 years ago
Copy Link
Try this pipeline:
StudentMarks_2020_07_08.slp (5.2 KB)

It looks like this:

The key step is the Mapper:

Here’s the expression on the third row:

$.entries()
.filter(pair => [‘student_id’,‘Total’].indexOf(pair[0]) < 0)
.map(pair => { Subject: pair[0], Marks: pair[1] })

Please see my article on Medium where I explore such transformations in more depth:

Medium – 19 Apr 21

Transforming and Visualizing COVID-19 Data

Step by Step Guide

Reading time: 11 min read

StudentMarks_2020_07_08.slp5 KB
cstewart
Former Employee
6 years ago
Copy Link
Have you tried the Pivot Snap?
- ptaylor
  Employee
  6 years ago
  Copy Link
  Wow, can’t believe it took me this long to learn of the Pivot snap. 🙂
  
  Yes, that works nicely for this:
  - mjain
    New Contributor
    6 years ago
    Copy Link
    Thank @ptaylor It works
- mjain
  New Contributor
  6 years ago
  Copy Link
  Thanks @cstewart It works

Forum Discussion

Extend columns into Rows without using Copy Snap

5 Replies

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?