combine csv file with different headers, number of column and sorting

[Anonymous]

Hi,

I have2 different ticketing tools that provide 2 different csv files extraction 

First CSV

RFC_NUMBER	DESCRIPTION	PRIORITY	END_DATE_UT	STATE
S190434118_004	DESCRIPTION1	1	2019-01-18 17:04:00.000	CLOSED
S190112348_004	DESCRIPTION2	4	2019-01-18 17:04:00.000	OPEN
S194301518_004	DESCRIPTION3	3	2019-01-18 17:04:00.000	TO CLOSE

Second CSV  

Ref. DIM	Etat	Priorité	Date
324786234	à clôturer(S)	0	01/01/2019
234432545	à clôturer(S)	0	28/12/2018
534543456	à clôturer(S)	0	26/12/2018
534453345	clôturée(S)	0	17/12/2018

Is it possible to combine it and how, please ?

Thanks

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may use Append Queries (Table.Combine) in Query Editor or SELECTCOLUMNS and UNION in DAX.