Populate space to the output column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Populate space to the output column
Hi,
I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.
Thanks,
I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.
Thanks,
Ajitha S
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Re: POPULATE SPACE TO THE OUTPUT COLUMN
Hi,
1. Float data type should not contain space.
2. Anyway, if you load data into database with space automatically it may ignore the space.
3. Still if you need space, use transformer stage and Concatenate with space but the target column should be character.
Thanks
1. Float data type should not contain space.
2. Anyway, if you load data into database with space automatically it may ignore the space.
3. Still if you need space, use transformer stage and Concatenate with space but the target column should be character.
Thanks
Sivakumar
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Re: POPULATE SPACE TO THE OUTPUT COLUMN
The answer is simple - it cannot be done. Get a new requirement... for example, is the field nullable? Can it be represented as a string?ajithaselvan wrote:I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Sure craig. This will not be repeated.chulett wrote:Ajitha S - please don't post in all capital letters, it is considered SHOUTING. I corrected your post Subject for you, so more of just an FYI. Thanks.
Regarding my query,
I'm funneling 2 inputs of same columns. column(col3) from input 1 throwing a value. column(col3) from input 2 will be written as space.
I'm not storing it in table. I'm sending as fixed width file.
Eg;
col1,col2,col3
1,2,3
1,4," "
Is there anyother way to achieve this?
Thanks in advance
Ajitha S
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Re: POPULATE SPACE TO THE OUTPUT COLUMN
It can be nullable. But it can not be representated as string.chulett wrote:The answer is simple - it cannot be done. Get a new requirement... for example, is the field nullable? Can it be represented as a string?ajithaselvan wrote:I need to populate space to the output column.The data type for the column is float(2,5). Kindly help me to resolve.
Regards,
Ajitha S
Re: POPULATE SPACE TO THE OUTPUT COLUMN
Actually, everything in a file is a string so it can. Set it to NULL and then edit the column so the 'null value' property is the appropriate number of spaces.ajithaselvan wrote:It can be nullable. But it can not be representated as string.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Re: POPULATE SPACE TO THE OUTPUT COLUMN
Hi Craig,chulett wrote:Actually, everything in a file is a string so it can. Set it to NULL and then edit the column so the 'null value' property is the appropriate number of spaces.ajithaselvan wrote:It can be nullable. But it can not be representated as string.
It didn't work. populating zero.
Regards,
Ajitha S
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Before funneling, in both the inputs for the particular columnchulett wrote:Then you missed something. Tell us exactly what you did to correct this - how you made sure the output field was null at the right time and what exact properties you set for that field.
1. Set the field as nullable
2. In Extended proerties, set null filed value as required space
As it is not necessary that the field should be null or not null, i have changed.
Regards,
Ajitha S