Trailing/Footer Record | Community
Skip to main content
derrickr8850025
Level 2
January 18, 2019
Solved

Trailing/Footer Record

  • January 18, 2019
  • 5 replies
  • 3082 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

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

Thanks,

-Jon

5 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
January 18, 2019

Hi,

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

Thanks,

-Jon

derrickr8850025
Level 2
February 6, 2019

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

Jonathon_wodnicki
Community Advisor
Community Advisor
February 6, 2019

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

ravitejagundu
Level 3
March 1, 2019

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.

Jonathon_wodnicki
Community Advisor
Community Advisor
March 1, 2019

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.