i have a 2 requirements
1)
Code: Select all
i/p o/p
a a
b b
c c
1 01
2 02
3 03
4 04
5 05
6 06
7 07
8 08
9 09
10 10
i have declared stage variable and wrote if else like below...
if col=1 or col=2 or col=3 or col=4 or col=5 or col=6 or col=7 or col=8 or col=9 then 0||col
else col...
then used this variable in derivation
is there any better way to do this
input column is of varchar type so as o/p.............
2)
in one of case
i/p------------>trx--------------->file
i just wanted to pass the values through transformer to o/p file
but there was no data coming from i/p file so o/p is empty.
so i just hard coded the value..but that was the case when no data coming...since this was weekly file next time if data come through input file then o/p will not those values...
so i declared a stage variable and set flag
if inrownum<>0 then o else 1
now in trx derivation i wrote
if sv=0 then inp_colm else 'value'
its not working ...i just need to pass some hardcode value in case there is no value in input.
hope i m clear.....
Many many thanks in advance.
Cheers!!!!
Devesh