derviation logic with derviation substituion $1 logic
Posted: Fri Oct 12, 2012 7:49 am
hi all
I have requirement I have 600 coulmns in xfm were I need to put same derviation for all 600 columns except numbering which is highlighted below.
Trim(Field(svREC, svnewdel,1),svquote,'B')
Trim(Field(svREC, svnewdel,2),svquote,'B')
Trim(Field(svREC, svnewdel,3),svquote,'B').
.............................................
.................................................
Trim(Field(svREC, svnewdel,600),svquote,'B')
what I did is I used $1 logic from derivation substitution which set Trim(Field(svREC, svnewdel,1),svquote,'B') for all 600 columns
but again I am doing manually changeing the numbers in the dervaiton like this we have 100 jobs to do so this takeing long time. Is this is possible?? if it can done really help me
Thanks M
I have requirement I have 600 coulmns in xfm were I need to put same derviation for all 600 columns except numbering which is highlighted below.
Trim(Field(svREC, svnewdel,1),svquote,'B')
Trim(Field(svREC, svnewdel,2),svquote,'B')
Trim(Field(svREC, svnewdel,3),svquote,'B').
.............................................
.................................................
Trim(Field(svREC, svnewdel,600),svquote,'B')
what I did is I used $1 logic from derivation substitution which set Trim(Field(svREC, svnewdel,1),svquote,'B') for all 600 columns
but again I am doing manually changeing the numbers in the dervaiton like this we have 100 jobs to do so this takeing long time. Is this is possible?? if it can done really help me
Thanks M