Forum Discussion
Unable to append the data
Hi,
I have two files:
a. CSv file which has data from dec-2019 till May-2020
b. CSV file with June-2020 data.
All the columns are exactly same. I get two errors:
a. While uploading June csv file it shows error , however that is sorted because i save it as excel now and it uploads.
b. But, while running the append query in transform tab, june data is not getting appended in my dec-may file. I get this error and see that the fields are now no reflecting under right column category.
I clicked on "close and apply" but it still shows as 7,457 rows whereas it should have addded another 1350 rows from June 2 file.
2 Replies
Hi Anonymous,
In your screenshot I have notice that you have some errors table on top of your query, are they refering to the file you are attempting to append?
Also be check that the information columns have the same name and the same format.
Anonymous , there are two errors on the top in yellow. Can just open and check. There can data format issues.
Refer how to handle
