Skip to Content (Press Enter)
2023-06-27 05-52-18
A L L Y
30Views
3Comments
Solved
How to compare two Id's in a different excel file?
Question
Reactive
Import/Export Data
Application Type
Reactive
Service Studio Version
11.54.6 (Build 62311)
Platform Version
11.18.1 (Build 37828)

Hello,


I need help, how can I match two Id's in a different excel file?


Here's the scenario:

  1. I have "Select File" button which I need to Import the first file named "First_EmployeeIDNumber". Once you click the excel file it will automatically export the data into the table then,
  2. I have table named "Employee" where you can now see the exported data coming from the input file/excel file then,
  3. I have "Match" button once I click this button it will ask me again to "Select Another File" for matching, once I click/choose the file that I want to match to first file it will automatically match the "Second_EmployeeIDNumber". After matching,
  4. I have "Export into CSV" button which I need to Export only the "EmployeeIDNumber" have the same ID to another file, inside on the csv file.

I have UI like this:

Thank you!

Second_EmployeeIDNumber.xlsx
First_EmployeeIDNumber.xlsx
0
0
05 May 2023
Copy Link
2026-02-26 06-29-24
Rahul
 
MVP
Solution

Hi,

You need to build a logic like - 

Once First file uploaded in Employee Entity then When you upload second file and click on match button so run one server action like-

ExceltoRecord - Run a loop - one by one ID match with Employee aggregate if ID return then it is a match otherwise no. Once id match then use another structure and bind a record in it.

And download this structure in excel file.


Hope this will help you.

 

3
0
05 May 2023
Copy Link
2023-06-27 05-52-18
A L L Y

Great! Thanks for your help, I appreciate it.

0
0
08 May 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.