I am getting the header and detail records in the same file. they dont have a common key. what i am supposed to do is to break each file depending on a fixed header rows and then load them to a seperate file, But we need a Common key to join them in the ETL so the Number i wanted to append at the end of each record will act as a reference and helps me to do that. I am able to split the File in to 2 parts depending on the no of header records.

but where i am stuck is i have to append a number at the end of each line in a file and that number needs to increment for each file

Below is my code

#Arguments
DIRECTORY=$1
FILE=$2
NO_HEADER=$3

#Validating the Arguments

if [ $# -lt 1 ]
then
echo
echo "\n Error :$0 Usage Input File \n"
echo
exit 1

# splits up the Header File

head -$NO_HEADER $DIRECTORY/$FILE > $DIRECTORY/${FILE}.head

echo `cat $DIRECTORY/${FILE}.head | awk 'BEGIN {FS = "," } ; { printf ("%s,", $2) }'` > $DIRECTORY/${FILE}.Header

rm -f $DIRECTORY/${FILE}.head

#calculates the remaining records in the File and writes them into the Detail file

NO_TAIL=`expr $NO_LINES - $NO_HEADER`

tail -$NO_TAIL $DIRECTORY/$FILE > $DIRECTORY/${FILE}.detail

Please help