- Posts: 109
Ignore duplicate line(s) of data
- JD Cox
- Topic Author
- Offline
- User
Less
More
5 years 11 months ago #3492
by JD Cox
Ignore duplicate line(s) of data was created by JD Cox
One of our customer’s system is mysteriously duplicating lines in some orders. Their IT department is trying to find solution. But, until they do they’ve reached out to me and ask that we ignore duplicates in the order file. I’m trying to create a .NET to identify the duplicates and change the item to ‘xxxx’ so I can filter it on the other side. But, I’m not having any success. Ignoring it in the .NET script would be even better. In the attached file there are three orders with two lines each. I want to ignore the second line for order B456.
As always, thanks for the help.
As always, thanks for the help.
Attachments:
Please Log in or Create an account to join the conversation.
- JD Cox
- Topic Author
- Offline
- User
Less
More
- Posts: 109
5 years 11 months ago #3493
by JD Cox
Replied by JD Cox on topic Ignore duplicate line(s) of data
Well...I never thought of using GroupBy. I use it all the time to combine duplicates and sum the quantities.
I guess I was over thinking it. Thanks, I got it.
I guess I was over thinking it. Thanks, I got it.
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
5 years 11 months ago #3494
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic Ignore duplicate line(s) of data
Just for your information. A better way to filter duplicate lines/contentis to use the
Filter Heater
with the enabled option “Filter duplicates out”, like the screenshot below.
Note: To use the GroupBy Heater for filtering duplicate line just working when the input stream is sorted based on the grouped field!
Note: To use the GroupBy Heater for filtering duplicate line just working when the input stream is sorted based on the grouped field!
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 or Create an account to join the conversation.
- JD Cox
- Topic Author
- Offline
- User
Less
More
- Posts: 109
5 years 11 months ago #3495
by JD Cox
Replied by JD Cox on topic Ignore duplicate line(s) of data
Thanks Robert,
That is a better option and clears up the line count issue I was having with the GroupBy.
JD
That is a better option and clears up the line count issue I was having with the GroupBy.
JD
Please Log in or Create an account to join the conversation.
Time to create page: 0.275 seconds