Skip to Content
avatar image
Former Member

get Counter for my target field

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 25, 2011 at 08:09 PM

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

    Posting source structure will be helpful

    rgds

    gab

    Add comment
    10|10000 characters needed characters exceeded