Community & Support
Learn
Marketplace
Menu
Menu
Home
›
Discussions
›
Community Q&A
Need data to be convert in below format as mentioned
sgnarkhede2016
New Altair Community Member
May 3, 2021
Updated
Nov 5, 2024
by
Jocelyn
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
All Replies
Accepted Answers
Sort by:
Sort by
Oldest
▾
1 - 1 of 1
↑
1
↑
YYH
Altair Employee
Accepted Answer
May 3, 2021
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
Sort by:
Sort by
Oldest
▾
1 - 1 of 1
↑
1
↑
YYH
Altair Employee
Accepted Answer
May 3, 2021
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
View in context
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
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