Need data to be convert in below format as mentioned

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 5 in Community Q&A
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

Tagged:

Best Answer

Answers