Enable Profiled Load in MC2

Owned by Marius Navickas
Last updated: Jun 12, 2024 by Pamela Totas (Deactivated)
1 min read

To enable Expert Mode in Solution Explorer:

  1. Right click on workflow name in solution explorer and choose Properties:

Enable Expert Mode in properties and save changes (Expert Mode can be already enabled).



After expert mode is enabled Preproc and Postproc panes will be available
(in the very bottom of IWS designer):

Switch to Preproc pane:

Click Edit on get_in_params data query shape (first shape on Preproc pane) and switch to Preview tab:

Change second row with text:

<CODE>IF Find(:FILE_NAME:, :corrIdSep:) = -1 AND Find(:FILE_NAME:, '-', 2) != -1 AND Find(:FILE_NAME:, '_') != -1 THEN [ :CorrelationId: := SubString(:FILE_NAME:, Find(:FILE_NAME:, '-', 0, 2) + 1); :CorrelationId: := SubString(:CorrelationId:, 0, Find(:CorrelationId:, '_')); ];</CODE>

To:

<CODE>IF Stringlength(:CorrelationId:) = 0 THEN [ IF Find(:FILE_NAME:, :corrIdSep:) = -1 AND Find(:FILE_NAME:, '-', 2) != -1 AND Find(:FILE_NAME:, '_') != -1 THEN [ :CorrelationId: := SubString(:FILE_NAME:, Find(:FILE_NAME:, '-', 0, 2) + 1); :CorrelationId: := SubString(:CorrelationId:, 0, Find(:CorrelationId:, '_')); ]; ];</CODE>


Close data query and save changes by clicking Save in right lower corner:

Publish task changes.

After this change task will evaluate Correlation Id during MC2 profiled load execution correctly.