Skip to Content
0
Former Member
Jun 06, 2014 at 04:59 PM

Adding Counter value in Header level in daily basis

102 Views

Hi Experts,

I am sending transactional data from ECC to Third party using file.Here we are sending initial load files and incremental files.by differentiating these two file have to check the flag field.if flag filed value is coming as YES it is initial load and if it is NO then it should be incremental file.here customer asking add counter value as header for incremental files in daily basis. Per day we should get multiple incremental files at the time we should add '1' as header and next row we will populate the actual data. it keep on increasing the count value for header if incremental data is coming. please find the below example,

EX:

1. DAY 1 we have to generate 5 incremental files, for all 5 files header value should be '1

'file1:

1

1000|AAA

'file2:

1

1001|BBB

.

.

.

'file5:

1

1001|FFF

2. DAY 2 we have to generate 5 incremental files, for all 5 files header value should be '2'

'file1:

2

1000|AAA

'file2:

2

1001|BBB

.

.

.

'file5:

2

1001|FFF

Per day wise it has increase the header counter value like 1,2,3,........keep on increase daily basis.

here my scenario should be Proxy to file(FCC).

Appreciate your help.

Best Regards,

Sanjay.