I have input data from two different packages. One is in CSV format for the year 2015 and another in Xlsx format for the year 2016.
All the columns are matching and I have same columns in each data set. However I am not able Append the data as the "Datatype differs in two data set"
For e.g. Data type for Transaction date in CSV format and Xlsx format do not match.
I am just curious to know if there is any way to identify "Datatype
" of each column under two different sets of data and change them accordingly. So that I can append the data without any hassle.
I have attached sample data for your reference.
Your advice/suggestion is much appreciated!