Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
I want to pass the value at job level while manually running it , that too with in row1.name Instead of this u want to give row1.context.name where I can give context value at run time.
It is throwing an error now , is there any other way that i could achieve this.
As per the @nthampi, yes we can pass context variable at run time. But you are stating as you are getting an error, please let us know what the actual error you are getting and what did you tried. If you let us know the details of your requirement, it will be easy to community members to give you the correct solution.
You are trying to define the schema at run time. Since Talend uses schema based processing, you will have to write custom code to parse the data if your column details are changing at runtime. In this case, you will have to define a metadata in advance and based on the combination, you will have to dynamically build them using java codes.
I would approach this in slighlt different way. I would try to use file formats which are flexible in nature like JSON or XML and will define all the columns as tags in the definition. So if a column is not there, corresponding tag will not be there. But still we will be able to parse the data easily since our definition includes all the tags in advance.
Could you please try this method?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Once this schema is established, you can send the data with subset of it where some records will not have zipcode, some other without age etc.
End of day, even though your schema is fluctuating, you will have have an idea of the list of columns which can come to target database. So if you establish all these columns inside a JSON or XML, you can handle the data processing easily.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
