A2A update question
I have an A2A data feed to update the next month record. I want to replicate values to the remaining months of the year records.
For example, the report has these values:
ID Value Next month ID (calc text field)
Jun16 (any numeric value) Jul16
Jul16 (empty) Aug16
Aug16 (empty) Sept16
When I run the DF, I want to copy the numeric value to the next month (to jul16, for the first row of the report). When it gets to the second row, it should copy the previously copied value (in the first row) to Aug16, but instead it copies nothing.
It seems that Archer doesn't update the report at each row, so it copies the 'old' values.
Anyone knows if it's the way Archer works? Is there a better solution to replicate several records at once, with the values of a single record?
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
- Tips and Tricks
You are correct that Archer is not updating the report between each data row. When an A2A feed kicks off, it grabs the report from the system and stores it in a temporary file local to the server, then executes the rest of the data feed against that file.
I think the only way to achieve what you are looking for Augstin is to modify the default XSLT to grab the first value and store it in a XSLT variable along with outputting the variable so it appears in on the Source Definition tab to map it accordingly.