For Example :
Key Fact_Type FACT_VALUE
1 FF 10
1 FP 20
Output Results
Key FF FP
1 10 20
Currently, i am using stage variable to concatenate it. After Concatenate, the result will be FF|10|FP|20. After getting this result, i will use field to get the value.
If FF does not exists, my whole job will be screw up. Any better solutions?
Thanks in advance. :D
DCount / Concatenate
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Mon Apr 21, 2008 9:53 pm
- Location: SG
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 17
- Joined: Mon Apr 21, 2008 9:53 pm
- Location: SG
Bcos i am grapping the data from database. Although is known that the format will not change, there are times that records are rejected when it is load inside database.
If FF records does not load inside database. My whole job will go haywire bcos i am using field to determine. Are there any better idea around in doing it?
If FF records does not load inside database. My whole job will go haywire bcos i am using field to determine. Are there any better idea around in doing it?