...
<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:
anchor
After this change task will evaluate Correlation Id during MC2 profiled load execution correctly.