🥳 RAPIDMINER 9.9 IS OUT!!! 🥳

The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.

CLICK HERE TO DOWNLOAD

Need data to be convert in below format as mentioned

sgnarkhede2016sgnarkhede2016 Member Posts: 130 Contributor II
in Help
Hello
I have Input

INSTITUTION_ID PERIOD_INDICATOR PERIOD_SEGMENT ACCOUNT_INFO_DATE ABC CDE EFG
1 DAILY DAILY Apr 26,2021 0 100 100
1 MONTHLY MONTHLY Apr 26,2021 100 200 500

Need output in below format
INSTITUTION_ID PERIOD_INDICATOR PERIOD_SEGMENT ACCOUNT_INFO_DATE PELICAN_FIN_INDICATOR AMOUNT
1 DAILY DAILY Apr 26,2021 ABC 0
1 MONTHLY MONTHLY Apr 26,2021 ABC 100
1 DAILY DAILY Apr 26,2021 CDE 100
1 MONTHLY MONTHLY Apr 26,2021 CDE 200
1 DAILY DAILY Apr 26,2021 EFG 100
1 MONTHLY MONTHLY Apr 26,2021 EFG 500

Best Answer

  • yyhuangyyhuang Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 332  RM Data Scientist
    Solution Accepted
    Hi @sgnarkhede2016,

    what you need is the de-pivot operator. You can take a look at its tutorial process. Or try the de-pivot transformation under Turbo Prep.

    Cheers,
    YY
    BalazsBarany
Sign In or Register to comment.