Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am unable to pass new line character (\n) as context value for field "Row Separator" to tFileInputDelimited component.
Can you show us a screenshot of your job and let us know what happens when you run it? This could be caused by a couple of things. We need more info.
Below you can see I have declared Row Separator as context.IF_Row_seperator and in second snapshot passing that value as \n
I actually meant to show your job layout as well, but this gives me a clue. I suspect that the file you are loading is having it's escape character (/) escaped to make it behave as a literal. Try this, at the beginning of your job (or after your context file has been loaded), add a tJava and set your context variable there like below...
context.IF_Field_Separator="\n";
Then run your job. If that works, my suspicions are correct. This will have been done for good reasons, so I am not sure it is a bug.
Could someone clear my error, when I'm passing the context variable to Header Field in tfileinputDelimited component it throwing following error..