Need data to be convert in below format as mentioned

sgnarkhede2016

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

yyhuang

Hi@sgnarkhede2016,

what you need is thede-pivotoperator. You can take a look at its tutorial process. Or try the de-pivot transformation underTurbo Prep.

Cheers,
YY