Get the details of ignored records in transform maps.

kushi1
Tera Contributor

Hi all,

I was having 1083 records with me in excel,i want to update the data in alm_hardware table and don't wanted to create any new records.From the script

if(action=='insert')

ignore=true;

i updated some records (like asset tag,acquistion method)and some are ignored.

Now i want the details of those ignored records(like asset tag)may i know how to fetch these details.However from the i symbol i can see the details but i am unable to export those ignored records.

1 ACCEPTED SOLUTION

Harsh Vardhan
Giga Patron
2 REPLIES 2

sb1186
Kilo Guru

Hi Pooja,



You can go to the Import Set Row (sys_import_set_row) table, from the Navigation Menu, and filter the required Ignored imported data.


Here, you have a column, Target record, which would point out that an update on this record was ignored.


find_real_file.png


You can also export this data by right clicking on the header of the list layout and select Export > Excel, etc.


find_real_file.png



Let me know if this is what you were looking for.



PS: Mark this answer as Correct if it solved your query or hit Like/Helpful depending upon the usefulness of the response.



Regards


Supriya Bisht


Harsh Vardhan
Giga Patron

Hi Pooja,



Please check the thread below.



Import Sets: How to check ignored records?