Using Magic ETL

Abhishek_Singh
Abhishek_Singh Member
in Magic ETL

I have dataset where the values are like this. Column name item and dependent

Item Dependent

A x, y

Here I need new dataset where values should be like this by using the magic ETL. How to do this

Item Dependent

A x

A Y

Answers

  • DavidChurchman
    DavidChurchman Coach
    image.png

    It's basically 2 steps.

    1: split your Dependent column using the delimiter.

    2: unpivot your data long.

    I also use the "Alter columns" tile to drop unnecessary columns:

    image.png
    image.png
    image.png
    image.png
    image.png

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

    Please accept the answer if it solved your problem.

Categories