Forum Discussion
Append Date column
Anonymous
it often happens when one of the appended columns contains of space-symbol or tab or smth like [Datum ]
I copied/past both tables to two new Excel-sheets to discover a deviation. I discover one date value was 20-02-2019 instead of 20-02-19. So I changed this and both tables appended with each other. I also changed this value in the original tables, but the still didn't append. I still don't understand why it's working in the new Excel-file, but isn't working in the original file.
Anyway, I decided to copy/paste all values in one new table. It's not ideal, but at least I can continue now.
It would be helpful if PBI was able to give a notification which value(s) are preventing a table to append. It would save a lot of time.
Community ChampionHi Anonymous
1. are you sure you are making Append, not merge?
2. make sure, your column name Datum doesnt't contain any spaces or other symbols
Hi az38,
1. Yeah, I am sure.
2. I went through both columns. There were no deviations in the dates....
- az38
Anonymous
it often happens when one of the appended columns contains of space-symbol or tab or smth like [Datum ]
I copied/past both tables to two new Excel-sheets to discover a deviation. I discover one date value was 20-02-2019 instead of 20-02-19. So I changed this and both tables appended with each other. I also changed this value in the original tables, but the still didn't append. I still don't understand why it's working in the new Excel-file, but isn't working in the original file.
Anyway, I decided to copy/paste all values in one new table. It's not ideal, but at least I can continue now.
It would be helpful if PBI was able to give a notification which value(s) are preventing a table to append. It would save a lot of time.