I have created a CSV upload with a few columns. Going through the wizard everything looks good and fine, and my csv file is uploaded to a collection.
I updated the Data Profile to add one transformation:
When uploading, I'm getting a preview in which this To Lower Case transformation is not executed.
Also after submitting there is still all kinds of uppercase characters.
I've tried other transformations, set the Sequence to 2 (because it's the second column in the csf file), but all to no avail. The transformation is not happening at all.
I've also indicated the first line to contain headers, but in the collection this line is still added (did not expect this).
If I change a Varchar column to a Number column, I'm getting errors. That tells me the data profile is at least considered. But why not the transformations?
When I turn on debugging, I'm getting this (part of the) JSON:
{
"file-type":2
,"single-row":false
,"file-encoding":"AL32UTF8"
,"headings-in-first-row":true
,"csv-delimiter":","
,"csv-enclosed":"\""
,"columns":[
{
"name":"C001"
,"data-type":1
,"data-type-len":4000
,"selector":"ID"
,"clob-column":0
,"is-json":false
}
,{
"name":"C002"
,"data-type":1
,"data-type-len":4000
,"selector":"TITLE"
,"clob-column":0
,"is-json":false
}
There's no transformation information in there.
How can I transform my data?
Politely tagging @carsten-czarski-oracle
Klaas