cancel
Showing results for 
Search instead for 
Did you mean: 

get Counter for my target field

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You need to set context of input field to counter() function correctly

Posting source structure will be helpful

rgds

gab

Answers (0)