Hi,
Where can I find some documentation about that component ?
There's none in the Reference Guide.
Taking datas from a delimited file, I need to load a table which has XML fields.
I think the tWriteXMLField is the key.
But in that component output, I only manage to have a lonely XML field. (which is already a good thing)
How should I do to get that XML field along with the others normal fields in the same link ?
Thank you,
Nicolas
Thank you for that use case Shong,
After a few tries, I think I don't need to use the group by option.
I want to use this component only to facilitate the development of my jobs (it's easier to generate the XML structure from the name of the fields than concatenate the strings with the tags).
I managed to create the XML field, as in your example, but I don't know how to integrate that field into the table ?
In the output of my job, I would like to have the whole structure of my table containing the WML field, and not only the XML field.
Thanks for your help,
Regards,
Nicolas
Shong, The root of the problem is that the tWriteXMLField component only allows one output column, the XML. All the other data in the schema up to that point is lost.
Is the support for the free users of TOS is deliberatly uncomplete, or may we can find the answer underline by the question of these 3 users somewhere?
edit: here is an exemple of the problem describe:
farmtest is the column where the xml generated with the input column is formed ; it's OK, and well generated.
BUT, I also want to retrieve, 2 originals columns in my output link, here id & n
THE PROBLEM is that my 2 outputs columns id & n are EMPTY
any suggestion?