Forum Discussion

Jones's avatar
Jones
New Contributor III
3 months ago

Split BiBlend table based on dimension value

Hey Community,  So I am wondering if anyone has any smart idea how to split into multiple BiBlend tables when loading a file into workflow with workflow name Blend. My current DataSource is using...
Application Properties
  • JackLacava's avatar
    JackLacava
    3 months ago

    Instead of risking with Event Handlers, we could use a "Blend, Workspace" profile, so that we get a Dashboard after the blend operation - have a button there that triggers an Extender via Data Management, and do the SQL splitting in the Extender.

ckattookaran's avatar
ckattookaran
VIP
3 months ago

It is not straightforward. You can use a TransformationEventHandler, check whether the operation is Case Is = BREventOperationType.Transformation.BiBlend.EndBiBlendProcessing and then split your Table using SQL. I had to do this one for archiving purposes. The client didn't want it to be always an overwrite.

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 months ago

    Instead of risking with Event Handlers, we could use a "Blend, Workspace" profile, so that we get a Dashboard after the blend operation - have a button there that triggers an Extender via Data Management, and do the SQL splitting in the Extender.

    • Jones's avatar
      Jones
      New Contributor III
      3 months ago

      Thank you Jack,

      I actually ended up with doing exactly this, so happy to hear that this was recommended process!