pivot tile?

damen · 2025-03-04T21:36:43+00:00

There was an error rendering this rich post.

hi I am working in Magic ETL and am having a tough time knowing how to do what I am trying to do.

Below I have a dataset with 3 columns shown that I need.

What I need to be able to do is keep the msp last run date on the left hand side but then pivot the `delinquent payment 2` into column names then show the loan count

So it would look something like this

I am using a pivot tile in magic etl and cannot configure it the correct way, any suggestions?

This set up does not work

Find more posts tagged with

Magic ETL

Accepted answers

DavidChurchman

This should work:

That said, the format you have your data in already is ideal for most uses. You could also pivot it as is in a Pivot Table Card:

All comments

DavidChurchman

This should work:

That said, the format you have your data in already is ideal for most uses. You could also pivot it as is in a Pivot Table Card:

damen

Thank you!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of