Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Get Member from Header

user11963953Jan 14 2021

Hello Everyone
so we need to extract the member from the header of the CSV file (looks something like this:
!Entity=ABC
1101000;[ICP None];[None];3000;[None];4000;100

I have in Import Format in Amount the script:
def Get_APAC_Entity(strfield, strrecord):
AMM=strrecord.split[';']
if strrecord[0:2] == '!E':
global APAC_Entity
APAC_Entity = strrecord[8:11]
fdmAPI.logDebug('APAC '+ APAC_Entity)
return strfield

And in Entity:
def Set_Entity(strfield, strrecord):
return APAC_Entity

But I never manage to set the Entity to this value. As the Get_APAC_Entity does not get executed. Its like it just jumps over it. Im pretty sure that it was possible to do, but Im not 100% sure
Am I missing something? Is there a workaround?

Thank you in advance!

This post has been answered by user11963953 on Jan 18 2021
Jump to Answer
Comments