on 02-25-2011 3:52 PM
Hello,
Can you please let me know how to assign counter to my target filed...
i have my target JDBC structure as given below:
Test_db_mt
--statement1 (HEADER)
-
tablename
-
action
-
table
-
access
-
mat_ID (filed1)
-
country (filed2)
--statement2 (DATA)
-
tablename
-
action
-
table
-
access
-
mat_ID (filed1)
-
subID (filed2)
-
location
--statement3 (DATA2)
-
tablename
-
action
-
table
-
access
-
mat_ID (filed1)
-
subID (filed2)
-
design
So my output should be
HEADER
<mat_ID> <country>
1.................. IN
2.................. AP
3.................. EU
DATA1
<mat_ID> <subID> <location>
1............... 1.................. aaa
1............... 2................. bbb
1............... 3................. ccc
2............... 4................. eee
2............... 5................. fff
2............... 6................. ggg
3............... 7................. hhh
3............... 8................. kkk
DATA2
<mat_ID> <subID> <design>
1............... 1................. aa
1............... 2................. bb
2............... 3................. cc
2............... 4................. dd
3............... 5................. ee
3............... 6................. ff
HOW TO GET THE count of HEADER to DATA1 and DATA2?
i tried all the ways with default counter/index...but i am not able to achieve the above logic....So only option seems UDF code...i tried few udf codes available in SDN...but no success...
So could you please provide the exact UDF code for my above requirement...(appriciate if you provide complete UDF code.)
Edited by: SARAN on Feb 25, 2011 5:13 PM
You need to set context of input field to counter() function correctly
Posting source structure will be helpful
rgds
gab
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.