Reformat clause in joinkeys sortcard changes output counts.

Mounika Nemani · New User Joined: 25 May 2018 Posts: 5 Location: India

Hi,

I am trying to compare two files using a key and write paired records into the output file.
I am getting difference in the output file count everytime I change the reformat clause.

I have a month and year in file 1 (ex: 201805) and some transactions done everyday with the timestamp in file 2. I am matching both the files to get all the transactions done on this month of the year. but I am getting different output counts with change in reformat clause.

case1:
Input:
file 1: 1 record
file 2: 500000 records
sortcard:

Arun Raj · Posted: Thu May 31, 2018 9:23 pm

Are you sure, you are running with the same inputs on both cases?
AFAIK REFORMAT should not change the output record counts. It would just select which fields to pass to the output from the JOINed record. Can you post the SYSOUTs from both the runs?

sergeyken · Posted: Thu May 31, 2018 9:47 pm

Before asking for help from the forum (and not giving detailed essential information!!!), try to do carefully the following steps.

Re-run your test with minimal size of the second file. Not 50,000 but 5-10 records. Print or view carefully ALL input files, and ALL output files, for BOTH of your cases.

If there is still difference in output count, then find out yourself: which records exactly are different, and what may cause that behavior?

* * *

The information you presented GIVES NO CHANCE FOR ANYONE TO BE ABLE TO HELP YOU doing YOUR OWN job instead of YOURSELF. In short terms your question looks like this: