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

Add a line of data triggered by input data…

More
8 years 7 months ago #2410 by JD Cox
When our customer’s, customer purchases product B our customer would like to add product Z to the order. I’ve done this for others in the past with VBA in our WMS. But, there’s always a risk of duplication when the order gets moved around. I feel the safest way is to add product Z during the import. Any suggestions, much thanks in advance.

JD

Please Log in to join the conversation.

More
8 years 7 months ago #2411 by FlowHeater-Team
Replied by FlowHeater-Team on topic Add a line of data triggered by input data…
Hi JD,

It´s possible but a bit tricky. I´ve attached a short example.

With an IF-THEN-ELSE condition you decide with product is currently proceeded. In case of product “B” you have to duplicate the CSV record X times by using the GroupOut Heater . In your case you need just one copy of them. This is done with the Input parameter form the two X-Value Heaters . 0=no copy needed, 1=make one copy. Note: 2=make two copies …

Afterwards you need for each field you would like to have other content another IF-THEN-ELSE condition to decide which content should be adopt on the WRITE side. For this condition you need the AutoID Heater with enabled GroupOut option. With this you can build a condition like if AutoID = 2 use Product Z other use the original content.

Sounds hard but I guess with the example it should be clear and easy to handle.



File Attachment:

File Name: add-dynami...tput.zip
File Size:2 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.

More
8 years 7 months ago #2412 by JD Cox
You guys rock

Thanks FlowHeater-Team…thanks for the easy to follow instructions and example.

As always Robert, very helpful I will find other uses for this as well.

Thanks Again, JD

Please Log in to join the conversation.

More
8 years 6 months ago #2440 by JD Cox
Hey guys I’m still struggling with this. It’s overwriting one of the line items on the first order and adding the new item. In your example (zip) change the second line item “B” to “C”, run the def as it is and it will change the “C” to “Z”. We were forced to reship a couple orders, on our dime, until I was able to identify the problem. They’re manually entering the additional item where needed for now.

Please Log in to join the conversation.

More
8 years 6 months ago #2445 by FlowHeater-Team
Replied by FlowHeater-Team on topic Add a line of data triggered by input data…
Hi JD,

On my side the output is like expected. I guess you use an old Version? Please try it with the latest Version.

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
8 years 6 months ago #2462 by JD Cox
After updating and making a couple adjustments this works like a charm…thanks again Robert.

Please Log in to join the conversation.

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