You are adding an extra component that is not needed if you are wanting to create a table to show PART_NUMBER, FLIT_COMPONENTS and AMOUNT.
According to Splunk Docs, list() returns a list of up to 100 values of the field X as a multivalue entry. That is why you are getting multiple entries FLIT_COMPONENTS and AMOUNT for a specific field PART_NUMBER.
I recommend using rename instead of stats list(field) as new_field if you are just changing field names to show in the table. You also have a by IDs at the end of your stats but then do not keep it in your table command.
I would try to look at this search:
**
index=ibldc-db sourcetype="flit_info" OR sourcetype="flit_comp"
| dedup ID
| rename FLIT_INSTRUCTION_ID as IDc, DU as DISPATCH_UNIT, BUNDLE_COMPONENT as FLIT_COMPONENTS, RULE_ID as FLIT_RULE_ID
| eval IDs=coalesce(IDc, ID)
| makemv IDs
| table PART_NUMBER PLANT_CODE PALLET_TYPE CAPACITY FLIT_COMPONENTS AMOUNT DISPATCH_UNIT FLIT_RULE_ID UPDATED_BY
**
in the table part you can feel free to add or remove whatever fields you want to show at the end of your search.
Hope this helps!
... View more