Fetch Metadata values from Text file in Transformation Event Handler

Question

Hi Experts,
I am working on TransformationEventHandler rule in which we need to read the first 4 columns of a text file that is being uploaded to Workflow Import so I can do some sanity checks and error out if they are not correct.&nbsp;
Does anyone have sample code that reads the values of file? I checked everywhere but not much documentation on this.
Also, I placed this code in "ParseSourceData" BREventOperationType.&nbsp; Not sure if this is correct or need to put under "ParseTransformationRules"?
Thanks in advance,
PM
&nbsp;

DanielWillis · Answer

Hi MikkiNot directly answering your question, but I wanted to check if you'd considered / knew about being able to user a connector BR on a file based import. It basically sends the file straight to a BR and then you process it and send a data table back to the data source. If it quite an under the radar feature which I feel not many people know about which is why i mention it.Some info @ https://community.onestreamsoftware.com/t5/Community-Blog/Beyond-Flat-and-Delimited-Files-How-to-Load-XML-or-JSON-Data/ba-p/28185- Daniel&nbsp;

DanielWillis · Answer

Tried to offer some assistance twice but my posts keep getting moderated / rejected. Not sure if its automatic or not so trying again with this post without any detail. MG?

MG · Answer

I’ll take a look to see if I can see your original post and why it’s being filtered.&nbsp;

MG · Answer

Hi&nbsp;DanielWillis, Your post should be visible now.&nbsp;

Forum Discussion

Fetch Metadata values from Text file in Transformation Event Handler

Related Content

OS metadata

Cube/Metadata Design Question

Metadata Components - Overview

Transformation rule

Transformation rules mappings