Hi
I have sequential file with customerid,supplierid and Lookuphas file with
customerid and profit percentage.
SEQFILE
cus_id Supp_id
100 001
Hsh_file
cus_id Profit%
100 10
101 20
If the customerd is equal then based on the percentage i need to create one record with 10%
and one with 90%. So my target will be
cus_id Supp_id
100 001
100 002
How can i achieve this?.
Kindly throw some light on this.
TIA.
SEQFILE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi,
I AM GIVING THE CONSTRAINT AS "NOT(SPLIT PERCENTAGE)=0" GOTO THE RECORDS TO SEQ_FILE(WITH 90%).
IF MY SOURCE SEQ_FILE HAS 2 SAME RECORDS ,SPLITTING IS APPLIES ONLY THE SECOND RECORD.IF I HAVE 4 SAME RECORDS IT APPLIES TO LAST 3 RECORDS.
MY CODE IN STAGE VARIABLE svProfPercentage
IF INPUT.CUST_ID=HSH_CUST_ID THEN HSH_PROFIT Else 0
TIA
Code: Select all
----------------SEQ_FILE(WITH 90%RECORDS)
|
|
SEQ_FILE-------------->XFM------------->SEQ_FILE(WITH 10 % RECORDS)
^
|
|LOOKUP_HSH
I AM GIVING THE CONSTRAINT AS "NOT(SPLIT PERCENTAGE)=0" GOTO THE RECORDS TO SEQ_FILE(WITH 90%).
IF MY SOURCE SEQ_FILE HAS 2 SAME RECORDS ,SPLITTING IS APPLIES ONLY THE SECOND RECORD.IF I HAVE 4 SAME RECORDS IT APPLIES TO LAST 3 RECORDS.
MY CODE IN STAGE VARIABLE svProfPercentage
IF INPUT.CUST_ID=HSH_CUST_ID THEN HSH_PROFIT Else 0
TIA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom