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

Preventing Lookup to Fail

More
10 years 12 hours ago #2317 by Heinz
Preventing Lookup to Fail was created by Heinz
Hi there,

I use a Lookup function in my script, but when it fails (so it does not find a value) the entire process stops.

To try and prevent this, I though of using a SQL function that does a count of the number of items that woudl match the lookup, based on the same input value on the record.

SQL: SELECT COUNT(*) AS totalFound FROM wscalllog WHERE leadid = 1

I then send that to a IF / THen ELsE and filter if the value = 0, thus, if no value will be found, teh record should be ignored.

Everything seems ok, but when I run the script, I get a "The adapter does not support the Execute function - and it then shows the SQL with a parameter replaced?


I also include my script, but modified it to remove the MySQL password - but I can not provide valid test data since its contains cleint info, but I am sure you will be able to figure out what I am after.
Attachments:

Please Log in to join the conversation.

More
9 years 11 months ago #2318 by FlowHeater-Team
Replied by FlowHeater-Team on topic Preventing Lookup to Fail
Hi Heinz,

The solution for your inquiry is quite easy, you just have to switch in the SQL Heater the side where the SQL statement should be executed. The Excel Adapter currently doesn’t support the Data Lookup functionality.



But it should be a easier way to use just one SQL Heater instead of the Lookup Heater . Note: The Lookup Heater is outdated because the SQL Heater is more flexible.

I’ve modified our FlowHeater Definition. I’ll think it should be clear how it works.

File Attachment:

File Name: lookupproblem.fhd
File Size:15 KB

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.
Attachments:

Please Log in to join the conversation.

Time to create page: 0.274 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.