Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Enable 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.