Shell Programming and Scripting

cty_id,grade_val,g_val_2,g_val_3
001,10,20,30
002,,,40
003,100,,10


grade_val,g_val_2,cty_id
10,20,001
41,,002
100,1,003

city_id 001 doest have any mismatch

if 002
Mismatch at col grade_val : Null - 41
if 003
Mismatch at col g_val : Null - 1

echo Please enter your cty_id:
read id
while read id; do grep "$id" file.csv; done < file_1.csv

column	         1st file	  2nd file
city_id	    1	            1
grade_val	   10	           10
g_val_2	   20	           20

city_id 001 doesn't have any mismatch
Mismatch at col grade_val : Null - 41
Mismatch at col g_val : Null - 1

awk '
NR == FNR       {if (NR == 1)   for (MX=n=NF; n>0; n--) REF[$n] = n
                 else           TMP[NR] = $0
                 next
                }

FNR == 1        {for (n=NF; n>0; n--)   {if ($n in REF) CMP[n]=REF[$n]
                                         if ($n == SRCH) NSR = n
                                         HD[n]  = $n
                                         NL     = "Null"
                                        }
                 next
                }

                {n = split (TMP[FNR], IT)
                 EQU = 1
                 for (i=1; i<=MX; i++)  {T = IT[CMP[i]]
                                         if ($i != T)   {print SRCH, $NSR ": mismatch at", HD[i] ":", $i?$i:NL, "-", T?T:NL
                                                         EQU = 0
                                                        }
                                        }
                 if (EQU) print SRCH, $NSR, "doesn´t have any mismatch."
                }


' FS="," SRCH="cty_id" file2 file1
cty_id 001 doesn´t have any mismatch.
cty_id 002: mismatch at grade_val: 40 - 41
cty_id 003: mismatch at g_val_2: Null - 1