topic Re: Map string with "File Positional schema" in Talend Studio

Map string with "File Positional schema"

_AnonymousUser — Thu, 06 Oct 2016 22:53:37 GMT

Hello,
i have an input for my job and it's a String (i'm not reading file, just regular string).
I've made a "File Positional schema" for to be able split(map) my string to fields (columns) .

What a component should i use to map my string.?

simple example would be
tJava------->[tMap ????]------->[tLogRow]
1line String------->mapping--------->n columns.

Easy-dirty solution is write down a String to a file and then with tFileInputPositional read/map the file (1 line) to my 10 columns.
But for me it's a dirty way, useless IO just to map some thing that i already have in memory.

can you guide me to a cleaner solution please.

thanks

Re: Map string with "File Positional schema"

Anonymous — Fri, 07 Oct 2016 05:28:32 GMT

You can not use the schema defined in tFileInputPositional unless you are reading from a file. I will advise creating a User defined routine that can return you that structure by taking the string as an input and then you can use that function either in tJavaRow or tMap function.

Re: Map string with "File Positional schema"

_AnonymousUser — Fri, 07 Oct 2016 13:06:25 GMT

To give a full picture:
i receive a message from a queue, then i passe this message to a job for future processing (get needed fields, and make some mapping, create an output message)
its really pity that i need to write it down (to a file) to be able to out map to a schema.
about routine, i wonted to avoid java functions (substring... and all ather manual work), because i can do a half of the work in java native. what is point to use an integration tool then.
thanks anyway .

Re: Map string with "File Positional schema"

Anonymous — Fri, 07 Oct 2016 13:50:33 GMT

I did try few different things but unable to get any other approach working. I understand your point in reference to usage of Integration tool. I take it in different perspective that Integration tool is flexible enough to give you all these extra features

Re: Map string with "File Positional schema"

_AnonymousUser — Fri, 07 Oct 2016 14:14:45 GMT

thanks for your help,
but in my company we choose this tool, so everyone can understand and change jobs, even if they don't know java.

so i'll try to make a root that will have string input and and split it in 10 columns (output)

so colleagues can reuse it.

Re: Map string with "File Positional schema"

_AnonymousUser — Sat, 08 Oct 2016 00:31:26 GMT

hmm,

found this. talend outputstream so if i understand right it can write down to a stream (not a file).
i'm sad, i can't do it as inputstream.

Re: Map string with "File Positional schema"

_AnonymousUser — Mon, 10 Oct 2016 08:22:27 GMT

OMG. i think i got it.

There is a component tExtractPositionalFields, i don't know why when i searched for "positional" in Palette, i didn't saw it.
so i'll try to make it work, because i was on my way of making a Java parser for my mapping.
have a nice day