how to load data from data source and store it in servicenow custom table

[Are Kaveri]

I have below requirement.

we have manual data coming for a table .

every year we receive data in form of excel data source .

after 2 continuous years  we need to validate the points obtained for student.

how to validate points from past two years on the table and load data on the table as year and points are different for each student.

the data is as follows

excel1

name	Title	Points Obtained	year
Test	IT	3	2022
Test1	Software	4	2022
Test2	Hardware	3	2022

excel2

name	Title	Points Obtained	year
Test	IT	5	2023
Test1	Software	3	2023
Test2	Hardware	4	2023

[AshishKM]

Hi @Are Kaveri ,

As you mention, its manual process ( data import via xml ) and it's not clear the goal of validation pre-data load in target table. You already know that you can process/validate the data during the transform phase ( source to target ). 

Do you have any column on target table which has to display/calculate the point variance from current year -> past year then you can apply onAfter script at transform map level of write a BR on target table. 

Let me know if this helps or explain more about data import process at your end. You share excel1 and excel2 data details, are you importing both in the same year of one excel per year then excel import process can validate point data using onAfter script. 

-Thanks,

AshishKMishra

[Are Kaveri]

Yes , we have a table called target table on which we need both data available for excel1 and excel 2.

and we are referring this particular variance on my request table for another validation.

so to store both year data on my target table how to load the data is my first question ?

Do I need to create past year points and current year points? 
I am not understanding how to achieve above problem ..

second question 

if I load entire data from excel 1 and excel 2 how can I do max(2022,2022) for my request table.

please assist me.

[AshishKM]

can you explain all this over call with screen sharing.

[AshishKM]

@Are Kaveri , if you know the data upload then you can upload both year data in same excel, after compare in transform map.