cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Romf Frequent Visitor
Frequent Visitor

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

Hi,

 

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

 

First CSV

RFC_NUMBERDESCRIPTIONPRIORITYEND_DATE_UTSTATE
S190434118_004DESCRIPTION112019-01-18 17:04:00.000CLOSED
S190112348_004DESCRIPTION242019-01-18 17:04:00.000OPEN
S194301518_004DESCRIPTION332019-01-18 17:04:00.000TO CLOSE


Second CSV  

Ref. DIMEtatPrioritéDate
324786234à clôturer(S)001/01/2019
234432545à clôturer(S)028/12/2018
534543456à clôturer(S)026/12/2018
534453345clôturée(S)017/12/2018

 

 

Is it possible to combine it and how, please ?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

@Romf,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

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

@Romf,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.