Options
Need data to be convert in below format as mentioned
sgnarkhede2016
Member Posts: 152 
Contributor II
in Help
Hello
I have Input
Need output in below format
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 |
0
Best Answer
-
Options
yyhuang
Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 364 
RM Data Scientist
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,
YY1
