Forum Discussion

mjain's avatar
mjain
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...
  • ptaylor's avatar
    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:

ptaylor's avatar
ptaylor
Employee
6 years ago

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: