Author |
Message |
Topic: Left Justifying both record count and total amount for dept |
sublak123
Replies: 1
Views: 1461
|
Forum: Utilities Posted: Wed Nov 15, 2017 12:38 pm Subject: Left Justifying both record count and total amount for dept |
I want to left justify the record count and total amount using inrec overlay/any other way in single step.
Input :
--------
010 000000012
010 000000013
... |
Topic: Left Justifying Trailer Count Field using Sort |
sublak123
Replies: 1
Views: 1543
|
Forum: Utilities Posted: Thu Nov 02, 2017 11:39 am Subject: Left Justifying Trailer Count Field using Sort |
OPTION COPY
OUTFIL FNAMES=SORTOUT,REMOVECC,NODETAIL,
TRAILER1=(1:1X, ... |
Topic: Left Justifying Section Count Field using Sort |
sublak123
Replies: 1
Views: 2178
|
Forum: Utilities Posted: Fri Oct 27, 2017 10:33 am Subject: Left Justifying Section Count Field using Sort |
Hi,
Please find the below sort card to display department-wise count of records.
OPTION COPY
INREC IFTHEN=(WHEN=GROUP,
... |
Topic: Combining two records into single record. |
sublak123
Replies: 1
Views: 1683
|
Forum: Utilities Posted: Wed Oct 11, 2017 7:17 am Subject: Combining two records into single record. |
Both Input & output file length is 133.
Input File :
TAMILNADU CHENNAI ANNANAGAR 10 20 30 40
TAMILNADU CHENNAI 6 7
TAMILNADU MADURAI KKNAGAR 05 10 15 20
TAMILNADU M ... |
Topic: Sort - Excluding groups based on condition |
sublak123
Replies: 3
Views: 1745
|
Forum: Utilities Posted: Fri Oct 06, 2017 8:49 am Subject: Sort - Excluding groups based on condition |
Input file:
1ABC-001
ABC TOTAL 1
0 12,300
ABC TOTAL 2
0 13,345
1ABC-002
ABC TOTAL 1
0 16,300
ABC TOTAL 2
0 17,345
ABC TOTAL 3
0 14,395
Outpu ... |
Topic: Pick Records matching the criteria using SORT |
sublak123
Replies: 24
Views: 6800
|
Forum: Utilities Posted: Tue Jul 04, 2017 9:46 am Subject: Pick Records matching the criteria using SORT |
Input File is Report File(FBA File) :
The report file contains data for several cities chennai,madurai,etc with multiple pages for each city.
Input file data is shown below.
HEADING :(PAGE ... |
|