Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Need data to be convert in below format as mentioned

sgnarkhede2016 · 2021-05-03T12:13:30+00:00

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…

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

Find more posts tagged with

AI Studio

Accepted answers

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

All comments

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