The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Need data to be convert in below format as mentioned

sgnarkhede2016sgnarkhede2016 Member Posts: 152 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, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 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
Sign In or Register to comment.