I have two files as such:
Name,Site Name,Product UPEI,Product Name,NMS Flag,Product Model, SW
NE_Name SW ABC 4.4 ASD 4.3 ... ...
Note that fileA just consists of a single line and it has several headers (eg, Name, Site Name etc.). Whereas, fileB has 2 fields with huge number of lines.
I want to combine these 2 files as such:
Name,Site Name,Product UPEI,Product Name,NMS Flag,Product Model, SW ABC,,,,,,4.4 ASD,,,,,,4.3
Thus, output file would have all the headers present in fileA and would expand the fields: 'Name' (with the 'NE_Name' values fetched from fileB) and 'SW' (with the 'SW' values fetched from fileB).
How can I get this output file from the 2 input files mentioned above?