Hello,
I'm trying to use a file connector to write a file but using a schema file and run time column propagation.
I need to use a schema file as my output delimiter will depend on the type of file I will generate as output.
I've read that for this I have to create a file, with the <output_file_name>.osh
For example if my output file name is :GBR_PERSON_100.txt
then the schema file should be : GBR_PERSON_100.txt.osh
Like this :
GBR_PERSON_100.txt.osh
record
{final_delim=end, delim='#', quote=double}
(
)
BUT this does not work.
Any idea of how to create a schema file for a file connector ?
file connector schema file
Moderators: chulett, rschirm, roy
What doesn't work about it? What errors / issues are you seeing? At this point just trying to gather diagnostic information so that those who have dealt with similar scenarios before (hint: that's not me, unfortunately) can provide more cogent help.
ps. At the very least, I can tell you that you need to provide all of the file's field/column definitions in the schema file so the RC has something to P.
ps. At the very least, I can tell you that you need to provide all of the file's field/column definitions in the schema file so the RC has something to P.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sorry but again all you are saying is "it doesn't work" with no details. What error messages are you seeing? No-one here can help guide you to get this working without knowing that. And have you involved your official support provider yet?
I would suggest posting your schema file again, in full this time.
I would suggest posting your schema file again, in full this time.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers