Need data to be convert in below format as mentioned
sgnarkhede2016
New Altair Community Member
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 |
Tagged:
0
Best Answer
-
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
Answers
-
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