find identical rows from excel

Posted by: psthariharan on 8 September 2017, 2:14 pm EST

  • Posted 8 September 2017, 2:14 pm EST

    hi

    is there any method or property to find identical or restrict duplicate rows based on condition

    while importing excel into spread.

    for example.

    in excel there are 4 columns: Name,Age,salary,Designation

    if name and age is same it is duplicate for the import

    Ram, 32  , 15000, developer

    Ram, 32 ,  25000,  developer

    how to avoid this duplication without loop checking. because loop checking will go in recursive and consume more time

    pls give me a solution for this

     

                              Hariharan 

  • Replied 8 September 2017, 2:14 pm EST

    Hello Hariharan,


    There is no direct property or method to restrict duplicate rows while importing Excel into Spread.


    Thanks.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels