I have two csv files. lets say Test_1.csv , Test_2.csv.
Test_1.csv file contains 260 columns (Fields) ( out of 260 fileds 60 fields has no data (these days comes from Test_2.csv file)), Test_2.csv has 63 columns. But both has the First 3 columns are same. Now I want to generate/Create a Final_Output.csv file with 260 columns.
Note: When I load both Files into QV, since many fields are same, QV getting hanged. So not sure how to resolve this issue.
Here I am attaching the Model csv files. I want tlo merger ABC_Data_1.csv , XYZ_Data_1.csv files and Output file should be similar to ABC_XYZ_Data_Output.csv. Here Custoer_ID, ID, Partner_ID are Keyfield in between two csv files. I want to merger fields from XYZ_data_1.csv to ABC_Data_1.csv file.