tJava Logic select

Karuetl — Tue, 15 Jan 2019 21:57:54 GMT

I need to write dynamic query if the number of columns in the table is 30 then it has to create below syntax using java ,if it is 10 then only 10 select columns to be created .. Kindly guide me

'select
NVL(a.$1,'''')|| ''^''||
NVL(a.$2,'''')|| ''^''||
NVL(a.$3,'''')|| ''^''||
NVL(a.$4,'''')|| ''^''||
NVL(a.$5,'''')|| ''^''||
NVL(a.$6,'''')|| ''^''||
NVL(a.$7,'''')|| ''^''||
NVL(a.$8,'''')|| ''^''||
NVL(a.$9,'''')|| ''^''||
NVL(a.$10,'''')|| ''^''||
NVL(a.$11,'''')|| ''^''||
NVL(a.$12,'''')|| ''^''||
NVL(a.$13,'''')|| ''^''||
NVL(a.$14,'''')|| ''^''||
NVL(a.$15,'''')|| ''^''||
NVL(a.$16,'''')|| ''^''||
NVL(a.$17,'''')|| ''^''||
NVL(a.$18,'''')|| ''^''||
NVL(a.$19,'''')|| ''^''||
NVL(a.$20,'''')|| ''^''||
NVL(a.$21,'''')|| ''^''||
NVL(a.$22,'''')|| ''^''||
NVL(a.$23,'''')|| ''^''||
NVL(a.$24,'''')|| ''^''||
NVL(a.$25,'''')|| ''^''||
NVL(a.$26,'''')|| ''^''||
NVL(a.$27,'''')|| ''^''||
NVL(a.$28,'''')|| ''^''||
NVL(a.$29,'''')|| ''^''||
NVL(a.$30,'''')
from'

Re: tJava Logic select

David_Beaty — Wed, 16 Jan 2019 12:59:16 GMT

This link on loops in Java might be what you need.

topic tJava Logic select in Talend Studio

tJava Logic select

Re: tJava Logic select