Interview questions for excel activities

Help Studio
, ,
1

this is one of the question asked by interviewer… there is an excel… with 1000 records in sheet1 and there is 1000 records in sheet2 also…if sheet2 is added more 100 records …how we will identify the lastest records… can any one plz expalin

2

Hi @katta_nikhil

  1. Use the Excel Application Scope activity to open the Excel file and select Sheet2.
  2. Use the Read Range activity to read the data in Sheet2 into a DataTable variable, let’s call it “dtSheet2”.
  3. Use the Filter Data Table activity to filter the data in “dtSheet2” to only show the latest 100 records. To do this, you can set the following properties:
  • DataTable: “dtSheet2”
  • Output DataTable: a new DataTable variable, let’s call it “dtLatestRecords”
  • Filter Wizard:
    • Select the column that contains the date or time stamp for each record (assuming such column exists) and set the filter criteria to show records that are greater than or equal to the date or time stamp of the 900th row (assuming there are 1000 records in Sheet2 before the new records were added).
    • Click “OK” to close the Filter Wizard.
  1. You can now use the “dtLatestRecords” DataTable variable to process the latest records as needed.

Note: If there is no date or time stamp column in Sheet2, you can use a different column to determine the order of the records (such as an ID or reference number), but you would need to make sure that this column has a consistent order for new records that are added.

3

Hi,
let’s assume ,in both the sheet one column is common.
Basically will we use Minus Operation to find the latest record.

4

but here the added items are not added under the remaining items … the new items added in the lace of 2,5, 100,104 ,200 row like that … then how can we get that … and if i dont have any reference or timestamp like that

5

but here the added items are not added under the remaining items … the new items added in the lace of 2,5, 100,104 ,200 row like that … then how can we get that … and if i dont have any reference or timestamp like that
[/quote]

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.