Variables in File Name

Forum|Forum|8 years ago
February 20, 2017
9 답변들
10040 조회

Hi,

I'm extracting a file and would like to include the campaign name in the filename.

<%= instance.label %> gives me the workflow name. This works perfectly.

In the script drop down I'm given the option to navigate to the Campaign level and select the following '<%= instance.operation.label %>', however on extract this supplies a blank and populates the filename with nothing.

I have the Campaign Name in the target data in the transition prior to the data extract. Can I use this? If so how?

Thanks in advance.

이 주제는 답변이 닫혔습니다.

최고의 답변: vraghav

Hi Alistair,

Even I'm finding it strange that instance.operation.label is not fetching the correct details.I'll check more on this with product engineers.

However, I do have a workaround available for your problem.

Inside the file export activity, on the advanced tab there is an Initialization Script section.
I'll create a variable that will hold the campaign label.
To fetch campaign label, fire a SQL query on database and get the result immediately.

Code to use in Initialization script will be

var myQuery = "SELECT O1.sLabel "; myQuery = myQuery + "FROM XtkWorkflow W0 JOIN NmsOperation O1 "; myQuery = myQuery + "ON (O1.iOperationId = W0.iOperationId) "; myQuery = myQuery + "WHERE W0.iWorkflowId = " + instance.id; vars.fName = sqlGetString(myQuery) + ".csv";

Attached is the snapshot of my test setup for reference.

Hope this helps.

Regards,

Vipul

alistairk396804작성자

Level 3

For some reason when creating using the instance.operation.label I am returning a null value which is confusing as the Campaign this workflow in running in has a populated label.

So I'm trying a new approach.

How do I replace the hardcoded text with a field held in my target data?

instance.vars.AKTEST = "Campaign Name"

I want to replace "Campaign Name" with the field @campaignLabel which I have appended in a previous enrichment.

vraghav

답변

Adobe Employee