How to combine 2 CSV file from different accounting system into 1 ?

[admin11]

Hi All

File A  Generate from SAP Accounting system :-

CUST_ID.............COMPANY...........INVOICE............DATE......................AMOUNT
1234.....................ABC........................123045..............12/11/2020.........1500
2324.....................XYZ........................120345...............11/11/2020.........2500
4544.....................DEF........................12345..................10/11/2020.........3500

File B Generate from Syspro Accounting system:-
COY.........................COY_ID.........INV..........................DATE..................AMT
ABC.........................1234...............123045.................12/11/2020......1500
ZYX .........................2324..............120345.................11/11/2020.......2500
DEF......................... 4544..............12345...................10/11/2020........3500

May i know how to Append file B into File A  ?

Paul

[AlexisOlson · Accepted solution]

Rename the columns so that they match and then append the queries.

[AlexisOlson · Accepted solution]

Rename the columns so that they match and then append the queries.

[admin11]

@AlexisOlson 

Thank you for your sharing.

After rename the field name for both file . do i also need to arrange the file column in sequences ?

Paul

[negi007 · Accepted solution]

@admin11 no need to arrange columns in the same sequence. only the names of the colums should be matching else it will create a new column in the appended table