Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Change Code?

Hi,
I created a tdbinput
then a tPerlRow
then a tdbOutput
the 3 objects are linked via main link input->perlrow->output
in the tperlrow i calculate the values for the output
il all works fine
But somethimes i would like to say to tdboutput not to write anything
to perform this i wrote the tperlrow so that it gives to the tdboutput the () value ( @tPerlRow_1=() )
i would like to let dbinput not to insert anything if the row in input is ()...
is it possible for me to modify the automatic code generated adding a if (@tDBOutput_1) before the push?
Or there is some other way?
thank u
Labels (2)
12 Replies
Anonymous
Not applicable

You can't know in the tPerlRow if it's the last iteration. But you can do it another way: instead of trying to know if it's the last iteration to perform a specific action, use a tPerl with a "trigger, run after" link, as illustrated by the screenshot.
Anonymous
Not applicable

Hi,
I would like to be able to run the following oracle commands within Talend. Is there a way?
drop table contr_catalog_newcols;
create table contr_catalog_newcols as select * from contr_catalog
where M_PRICE <> '-10.00%';
--add columns
alter table contr_catalog_newcols add
(mb_client_product_id varchar(100), mb_online_customer_price char(14));
commit;
--for product
--find m_clientproductid
update contr_catalog_newcols set mb_client_product_id=trim(substr(m_product_id, 1, instr(m_product_id, ':',1,1)-1));
commit;
update contr_catalog_newcols set mb_client_product_id=trim(m_product_id) where mb_client_product_id is null;
commit;
and then I can do my regular mapping
thanks,
bob
Anonymous
Not applicable

I was able to solve my own problem by trial and error. I eventually tried enough combinations and came up with an oracle error of ora-01003 which let me to use a tJava with several tOrarows and that did the trick for me