Edit Values of Table columns on importing excel

0
I am importing an excel in my application. The table has multiple columns but there are a few decimal type columns which i am importing. I need to multiply the values in these columns by 1000 while importing before showing in the table.     On import itself i want to multiply these values by 1000.   https://medium.com/mendix/how-to-import-excel-file-with-excel-importer-mendix-10-fb3a5276f26c   this is the method i am using to import the excel in my app.    
asked
1 answers
0

You can parse values when importing.  Documentation here:  https://docs.mendix.com/appstore/modules/excel-importer/#parse-with

 

Pranav,

You would

  • create a microflow that has one parameter of type Decimal or Integer, multiplies that parameter by 1000 and returns the resulting number
  • start up your model and synchronize the model using Model Reflection
  • in your Import Template, open the column you want to multiply and, in the Parse With property, select the microflow you just created

Hope that helps,

Mike

answered