Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

X-value doesn't copy to excel file

More
7 years 9 months ago #2726 by David
X-value doesn't copy to excel file was created by David
I have created X-values to add formulas to my excel file. However, when I execute the definition a blank value is passed to the excel file and not the X-value. How do I correct this? I am unable to get any value to pass to my excel file using X-values.
Attachments:

Please Log in to join the conversation.

More
7 years 9 months ago #2727 by FlowHeater-Team
Replied by FlowHeater-Team on topic X-value doesn't copy to excel file
Hi David,

I guess this issue is related to wrong data type setting for the Excel field “Balance due”. Please check whether the FlowHeater data type is set to “String” for this field.

Did you receive warnings about? Usually you should receive warnings because wrong conversions!

In case this does not solve the issue please post your FlowHeater Definition file for more analytics.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in to join the conversation.

More
7 years 9 months ago #2728 by David
Replied by David on topic X-value doesn't copy to excel file
Thanks Robert

Setting the data type to string solved the problem.

I reviewed the posting #2050 for passing formulas to excel. A much easier way is to set the range in excel as a table and pass formulas that reference the table names in the formula. Such as [=IF(AND([@LastUpdated]-[@DueDate]>30,[@LastUpdated]-[@DueDate]<=60),[@Balance],0)]

Please Log in to join the conversation.

Time to create page: 0.291 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.