Skip to Content
0

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

Sep 21, 2017 at 06:58 PM

50

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded

I have fixed you tags. Please select carefully.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers