https://community.qlik.com/t5/Talend-Studio/resolved-Using-static-lookup-tables-within-Jobs/m-p/2297287#M69878 Hi there, <BR />is there a way to use static lookup tables and make them part of the rollout package in Talend? <BR />Here's what I mean: <BR />I have created a Web Service with a simple Service implementation (Job Design View). <BR />This service fetches data from a database, then performs some sorting operations, then (and only then) prioritizes the remaining items by means of a lookup table. This table is simple: 20 entries that contain a string and a numeric value. If a certain field of a data row matches one of the strings in the lookup table, the numeric value is associated with the row as "priority". <BR />Right now, that lookuip table resides in a flat file - but Talend does not include that file in the .kar file when I build the service. <BR />So I am wondering if there is a component which acts an can be used like a table or flat file but whose values can be set "like in Excel" and which is persisted in the job as if it was a Java array (and therefore part of the code)? <BR />Thanks <BR />Matt Wed, 06 Aug 2014 19:07:28 GMT kleinmat 2014-08-06T19:07:28Z https://community.qlik.com/t5/Talend-Studio/resolved-Using-static-lookup-tables-within-Jobs/m-p/2297287#M69878 Hi there, <BR />is there a way to use static lookup tables and make them part of the rollout package in Talend? <BR />Here's what I mean: <BR />I have created a Web Service with a simple Service implementation (Job Design View). <BR />This service fetches data from a database, then performs some sorting operations, then (and only then) prioritizes the remaining items by means of a lookup table. This table is simple: 20 entries that contain a string and a numeric value. If a certain field of a data row matches one of the strings in the lookup table, the numeric value is associated with the row as "priority". <BR />Right now, that lookuip table resides in a flat file - but Talend does not include that file in the .kar file when I build the service. <BR />So I am wondering if there is a component which acts an can be used like a table or flat file but whose values can be set "like in Excel" and which is persisted in the job as if it was a Java array (and therefore part of the code)? <BR />Thanks <BR />Matt Wed, 06 Aug 2014 19:07:28 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Using-static-lookup-tables-within-Jobs/m-p/2297287#M69878 kleinmat 2014-08-06T19:07:28Z https://community.qlik.com/t5/Talend-Studio/resolved-Using-static-lookup-tables-within-Jobs/m-p/2297288#M69879 Hi Matt,<BR />I believe you can use a tFixedFlowInput for what you are doing. Define the schema then check off "Use Inline Table" and put your key/value pairs in there.<BR />--Matt Wed, 06 Aug 2014 19:57:28 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Using-static-lookup-tables-within-Jobs/m-p/2297288#M69879 Anonymous 2014-08-06T19:57:28Z