I have 3 tables -Table A, Table B and table C
Table C is has processed data from Table A, table C has 2 new columns which takes data from the join of table A and table B based on the some join condition on the columnns .
I want to develop a workflow which compares the data in table C and table A in which I want to perform the join on table A and table B and then the result of this
Steps I have taken:
I have read data from table A and table B and now I have to use join condition like TableA.C1 = tableB.c1 and TableAC2-tableBc2, then 'new_col after join should have tableB.c2 values if join gives null then ‘new_col’ will have value string prefix to ‘Fe’ in column TableA.C1, once I have the data I want to compare the data of the join to the data in table C .
can you tell me the approach to perform this action.