I'm trying to import a csv file via DV.
Additionally I'm trying to join a filepath column containing the respective filepath in each cell of the column.
As soon as I join the filepath column only the first character of imported csv columns are being displayed.
I've already tried to use other encodings but 'WINDOWS-1252' seems to be the right fit.
Expected behaviour: Four columns. No loss of data.
Actual behaviour: Four columns as expected. Loss of data in each imported csv column.
(CALL "some_server"."getFiles"("pathAndPattern" => '*.csv')) f,
TEXTTABLE(to_chars ("f.file", 'WINDOWS-1252')
DELIMITER ' '
WHERE f.filePath LIKE '%adform/lightspeed%'
AND data."Timestamp" IS NOT NULL;;
Help will be much appreciated.
Please sign in to leave a comment.