Skip to Content
avatar image
Former Member

Extract value from some column of my file in one global variable to use in second data flow in BODS.

Requirement is as follows:-

1. v_currentMsgID = if v_CurrentMsgId = 0 THEN ( if table.MSGID is null , 0 , table.MSGID ) +1,

ELSEIF( v_rowcount >= 25000 ) then v_currentMsgID+1 else

v_currentMsgID.

2. v_rowcount = v_currentMsgID <> v_prevMsgId , 1 , v_rowcount+1

3. v_prevMsgId = v_currentMsgID.

If MSGID coming from table is 1300

all variables are zero initially.

so the target will be something like below:-

MSGID = 1301 , v_rowcount = 1 , v_prevMsgId = 1301 for first row.

MSGID = 1301 , v_rowcount = 2 , v_prevMsgId = 1301 for second row till 24999

MSGID = 1301 , v_rowcount = 25000 , v_prevMsgId = 1301 for 25000th row

MSGID = 1302 , v_rowcount = 1 , v_prevMsgId = 1302 -- for 25001 row

As in BODS; I am thinking to use while loop for the same and do these assignments in Script. Please suggest some way?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers