Trailing/Footer Record

[derrickr8850025]

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?

[Jonathon_wodnicki · Accepted solution]

Hi,

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

Thanks,

-Jon

[derrickr8850025]

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

[Jonathon_wodnicki]

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]

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]

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.