Archive for March, 2009
Monthly Archive
Thursday, March 19th, 2009
Transform Question in DataStage
Found this old question in the Data Direct Technologies Forum. I think it makes a good example exercise, since it can be solved multiple ways, but is short enough to address in a single (long) post.
I have a record in this format
H,0002
L,B254,4
L,B221,19
L,B064,4
H,0001
L,B208,1
L,B186,8
H,0004
L,B178,17
L,B132,19
L,B121,17
L,B025,12
H,xxxx (xxxx represents the customer unique no)
L, yyyy.z (yyyy is the product part no, [...]
