Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |