Is it possible to do a straight map of source and target columns from a spread sheet ? I have a spread sheet which has over 200 columns being mapped to some 200 columns in my target. Instead of dragging and dropping every column in the transformer, I was wondering if someone tried something to make use of the mapping in the spread sheet in an automated fashion.
Thanks.
Mapping columns from a spread sheet
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Do you mean RunTime column propagation?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Re: Mapping columns from a spread sheet
Can you be more clear on this.
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
The column auto match was good. Wish we could do the same for similar sounding names, more like sounds like feature. Some columns are mapped to very different names in my spread sheet. The auto match feature doesnt work in that case. But Auto match did map about half the columns. A little helpful but not completely. Any other pointers ?
Thanks.
Thanks.
From what I recall, you can switch from doing a name match to a positional match. Which means if your output columns are all in the same order as the inputs that would work for you as well.
At that point, you might as well just do a 'Select All' on one side and drag them all over at once to the other side.
At that point, you might as well just do a 'Select All' on one side and drag them all over at once to the other side.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without even opening the stage, right click and choose Propagate.
Within the Transformer stage you can multi-select the input columns (click on the first, shift-click on the last) and do a single drag-and-drop.
The column definitions from the spreadsheet you have, of course, previously imported into your Repository so you can Load them in the job.
Within the Transformer stage you can multi-select the input columns (click on the first, shift-click on the last) and do a single drag-and-drop.
The column definitions from the spreadsheet you have, of course, previously imported into your Repository so you can Load them in the job.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.