Trailing/Footer Record

Avatar

Avatar

derrickr8850025

Avatar

derrickr8850025

derrickr8850025

18-01-2019

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

18-01-2019

Hi,

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

Thanks,

-Jon

Answers (4)

Answers (4)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

06-02-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

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

01-03-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.

Avatar

Avatar

ravitejagundu

Avatar

ravitejagundu

ravitejagundu

01-03-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.

Avatar

Avatar

derrickr8850025

Avatar

derrickr8850025

derrickr8850025

06-02-2019

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