Skip to Main Content

Analytics Software

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