Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Enable Expert Mode in Solution Explorer.
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.

  • No labels