Author Topic: Always show 8 digit number!!  (Read 1661 times)

Offline anjidwh.cognos

  • Full Member
  • ***
  • Join Date: Oct 2013
  • Posts: 44
  • Forum Citizenship: +0/-0
Always show 8 digit number!!
« on: 30 Apr 2014 12:47:37 am »
Hi

I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.

I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!

Regards

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,037
  • Forum Citizenship: +655/-10
  • Cognos Software Muppet
Re: Always show 8 digit number!!
« Reply #1 on: 30 Apr 2014 11:43:00 am »
Hi

I am getting 4 digit number from the flat file in one of the column. But how to show always 8 digit number even we get 2 or 3 or 4 digit number.

I have to show 8 digit number in my target table. Can anybody suggest how to achieve this!!

Regards

What do you mean by "show 8 digit number"? You are writing data to the table, not displaying it? If the column in your target table is defined as a numeric data type it makes no difference whether it is one digit or 8 passing through your build - it will be stored as a number. Can you explain further?

MF.
Meep!

Offline anjidwh.cognos

  • Full Member
  • ***
  • Join Date: Oct 2013
  • Posts: 44
  • Forum Citizenship: +0/-0
Re: Always show 8 digit number!!
« Reply #2 on: 01 May 2014 12:54:10 am »
From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253

Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.

customer number
---------------------
1020
25361523
1253

But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.

Regards


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,037
  • Forum Citizenship: +655/-10
  • Cognos Software Muppet
Re: Always show 8 digit number!!
« Reply #3 on: 01 May 2014 08:38:43 am »
From the file we are had data for one of the column like below:
customer number
---------------------
00001020
25361523
00001253

Here my question is while I am extraction file into build and write a simple select stmt for file, then values are shown like this.

customer number
---------------------
1020
25361523
1253

But I need complete 8 digit number how the file contains into my build also. Please help me to get out of this.

Regards

What is the data type of the column defined as in your text file definition in Data Manager? is it a number of some sort or a char of some sort? How do you want it to be stored in the table you are writing to?

MF.
Meep!

 



       
Twittear