Expand my Community achievements bar.

SOLVED

Trailing/Footer Record

Avatar

Level 2

Hi

I've created a data extraction within Adobe. Curious, but I need to add a trailing record that includes ABC and then the count of records in the file.

Any ideas?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Add a JS activity afterward appending to the same file 'ABC' + vars.recCount

Thanks,

-Jon

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Add a JS activity afterward appending to the same file 'ABC' + vars.recCount

Thanks,

-Jon

Avatar

Level 2

Would you be able to provide a sample that does this?

Avatar

Community Advisor

Hi,

From the product doc, put this in a js activity after extract:

var f = new File('c:/file.txt'); 

f.open('a'); 

f.writeln('ABC' + vars.recCount);

f.close();

Thanks,

-Jon

Avatar

Level 4

Hi Wodnicki

Is the trailing record is adding the same extracted file(.txt or .csv) or it is saving in the other file?

Thanks,

Raviteja.

Avatar

Community Advisor

Use the same name as extracted file, the 'a' arg to File.open() is append. Name may be available as vars.filename in the extract's transition, though more stable to just repeat the filename in case someone shuffles workflow around later.