|
|
Re: csv exports [message #1821380 is a reply to message #1821289] |
Wed, 12 February 2020 08:16 |
Thierry Poupon Messages: 18 Registered: January 2020 |
Junior Member |
|
|
Thanks
Since, I have found that the issue was not the separator, as Capella separates columns by brackets in addition to comma. When several values are in one column, they are only separated by comma. The issue is coming from several colomns. For some reasons the export process generates a wide matrix. By export process I include csv generation, and then save as xlsx. I expected a single column file, but I have a variable width matrix. So, importing the matrix into my main workbook, I need to run the query, add a column to concatenate all, and then run a second query to separate the columns again.
Is there anyway to understand the character that causes this column split? (It does not occurs between the same fields for all rows)... I understand Excel support is needed too.
Thanks
I try again to migrate to 1.4.0 (from 1.3.0)...
|
|
|
Powered by
FUDForum. Page generated in 0.02497 seconds