Excel wr

@All please I need help in solving the above question about write data in Excel that will enable the field show large numbers

What is the datatype of the attribute in FME and what is the output type of the attribute in the writer?

The data type is Excel, I can send you the datatype.

​@hkingsbury I have attached the Excel sample data

I’m meaning the dataype of the attribute in FME

and what the attribute is set to in the reader
 

​@hkingsbury   Default FME Data Type is = UTF-8
Default attribute is set to in the reader = number

​@hkingsbury  Which Transformer and Approach can I use to achieve the process.

Looking at the excel sheet you attached, Excel is displaying the values in scientific notation. You can format the cells as Number and change it to 0 decimal places and they’ll appear like so:

 

I also tested setting the output attribute type in the writer to string and that worked (without needing to change the cell format in excel)
 

​@hkingsbury The challenge here is that the remaining code is turned to zeros (0)
 

I will want it to appear in full, just like what I have on the cin column on database. Check the image below.
 

Hi ​@evoteck, lets see whether I can give you some support. The fastest way to solve this can be done in Excel itself I guess.

Steps:

1. Visit your Excel data again
2. Select your column with data completely 
3. Select the type of data this column should be
4. Choose Number
   In my Excel it shows Getal which is Dutch for number

​@lambertus Changing it number is what ​@hkingsbury did earlier, but that will change other part of the numbers to zeros (000000), which is not the same with the actual figures from the database.

​@lambertus and ​@hkingsbury  I was able to solve the issue using Attribute Manager Transformer to change the data type for the cin, to accept large numbers .
 

And the output in excel is showing correctly

​@evoteck you're right, glad that solved the issue yourself 😃

​@lambertus Thanks I really appreciate your time and your help.