pivot tile?

damen

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

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:

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!