May 12, 2010 at 8:47 am
Hi,
I'm reading data from a flat-file, and the data is in the following format:
Table=A, Column=B, Data=C
Table=D, Column=E, Data=F; Table=G, Column=H, Data=I
Table=J, Column=K,Data=L; Table=M, Column=N,Data=O; Table=P, Column=Q,Data=R
I have three destination columns called Table, Column and Data, into which I would like to insert the respective values.
The catch is, I don't know how many times the same Table-Column-Data combinations will occur in a single record. I am looking to get an output like this:
TABLECOLUMNDATA
===============
ABC
D/GE/HF/I
J/M/PK/N/QL/O/R
and so on, where multiple values are put into the same column, delimited by a '/'.
I've been trying quite a few approaches but I've not been able to achieve this so far. It would be great if someone could help me out here.
Thanks!
Regards,
GS
May 12, 2010 at 9:01 am
That's quite unpleasant.
You will need to read in the source data as a single string (no column delimiter) and then use a Script Component to parse & reformat the data for output to three columns. I don't see any way that can do it without a chunk of code.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply