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

YYH

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

YYH

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