Logic results changing from small dataset to larger dataset

  • Posts: 8
  • Thank you received: 2

Logic results changing from small dataset to larger dataset was created by jheinzAP

I am processing If then logic through each of 4 transformations. When I test for 5 records of single item, logic output is correct. However, when I run entire file of 8700 records across many items, logic results for same tested item changes to incorrect result. I have tried all 4 logic steps in 1 transformer using calculator but get same behavior. I also tried using data buffer but didn't change results. What can I do to get script to behave with large recordset same as when I use small recordset?
3 months 16 hours ago #20011

Please Log in or Create an account to join the conversation.

  • Posts: 7951
  • Karma: 33
  • Thank you received: 495

Replied by admin on topic Logic results changing from small dataset to larger dataset

We can't help you because you have not provided us with enough information.
Please read the forum rules and follow them.
Mike
3 months 16 hours ago #20012

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 2

Replied by jheinzAP on topic Logic results changing from small dataset to larger dataset

Application Name : Advanced ETL Processor Professional 64 bit
Version number - 6.3.6.15
Operation system version - Windows Server 2016 Datacenter
Database version - SQL Server 13.0.1601.5
Repository type - SQL Server
All the symptoms of the Problem - previously listed
Exact steps required to reproduce it - Create sql table per attached script and flat file. Connect lookups to attached excel file. Run script limiting common_stock_no to 771101 and view trans-type results. Run script with all common_stock_no and see results for 771101 change.
Log files - attached
Data samples - attached
Mapping as file - attached
SQL script to create tables - attached
Screenshots (Entire screen) - attached
3 months 10 minutes ago #20014

Please Log in or Create an account to join the conversation.

  • Posts: 7951
  • Karma: 33
  • Thank you received: 495

Replied by admin on topic Logic results changing from small dataset to larger dataset

Thank you.

We will have a look at it for you
Mike
3 months 4 minutes ago #20016

Please Log in or Create an account to join the conversation.

  • Posts: 7951
  • Karma: 33
  • Thank you received: 495

Replied by admin on topic Logic results changing from small dataset to larger dataset

We also need this file

C:\Users\jheinz\Documents\Data Transfer\Inventory\Inventory_072920.txt
Mike
2 months 4 weeks ago #20017

Please Log in or Create an account to join the conversation.

  • Posts: 7951
  • Karma: 33
  • Thank you received: 495

Replied by admin on topic Logic results changing from small dataset to larger dataset

This one is missing as well

C:\Users\jheinz\Documents\Data Transfer\New Items\Build list\2020 CARB BUILD PRIORITY BY FACTORY RELEASE RECORD.xlsx
Mike
2 months 4 weeks ago #20018

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies