Transform Map does not working

[felipe14]

Hello everyone, I have a problem, my transformation map is not working correctly, it only recognizes 1 record within Excel and simply ignores the rest. both ixist in cmdb my coalesce is the access id and the line

record found 

 

record not found

 

[akashsingh20234]

• Check Import Set Table

  • Go to System Import Sets > Import Set Table

  • Ensure all rows from Excel are imported.

• Verify Coalesce Field (Access ID)

  • In the Transform Map, ensure Access ID field has Coalesce = true.

  • Each row in Excel must have a unique Access ID.

• Check for Duplicate Access IDs in Excel

  • If multiple rows share the same Access ID, only one record will update.

  • Fix by ensuring all Access IDs are unique (if updating different CI records).

• Check Excel Format

  • Save as .xlsx, avoid merged cells or formulas in Access ID.

  • Clean and re-upload the file.

• Review Scripts (if used)

  • Check onBefore or onAfter scripts in the Transform Map.

  • Make sure no logic is skipping records.

• Run Transform Again

  • Ensure “Copy empty fields” is unchecked.

  • Monitor how many records are processed.
    
    
    please mark it helpful

[felipe14]

já fiz todos esse passos previamente, o problema está no campo u_line de algum modo o transform map não está reconhecendo essa sequencia de números  

[Pratiksha]

You should be using IRE for CMDB. Use integration hub ETL. It will be better. 

[felipe14]

boa sugestão mas não se aplica no projeto atual, vou  considerar isso nos próximos