pivot tile?

damen
damen Contributor
edited March 4 in Magic ETL

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

image.png

So it would look something like this

image.png

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

This set up does not work

image.png

If this helps, feel free to agree, accept or awesome it!

Tagged:

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    This should work:

    image.png image.png

    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:

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    This should work:

    image.png image.png

    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:

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • damen
    damen Contributor

    Thank you!

    If this helps, feel free to agree, accept or awesome it!

Categories