- Posts: 35
- Thank you received: 0
Changing position of Columns in Writer
8 years 3 months ago #13091
by gia
Changing position of Columns in Writer was created by gia
Our target file - writer object has a new structure where position of three columns has been changed(out of 100 plus fields), if we import the new target our existing code becomes unusable. Please suggest if there is a way to move the position of columns in writer so that we can continue to use the same ETL code. Thanks!
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 3 months ago #13092
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Changing position of Columns in Writer
1) place another transformer before writer
2) Point writer to the new file (I assume that it have field names at the fist line)
3) Right click on the grid and select autoformat grid
4) Right click on thegrid and select "Autoformat grid"
5) Right click on the grid and select "Set first line as fields names"
6) Open tranformer created at the first step and perform automap
use this transformer for mapping only
2) Point writer to the new file (I assume that it have field names at the fist line)
3) Right click on the grid and select autoformat grid
4) Right click on thegrid and select "Autoformat grid"
5) Right click on the grid and select "Set first line as fields names"
6) Open tranformer created at the first step and perform automap
use this transformer for mapping only
Peter Jonson
ETL Developer
The following user(s) said Thank You: gia
Please Log in or Create an account to join the conversation.