Validation required while importing data

[pramn]

Morning Guys, 

Need your Assistance to fix the issue , Actually we are Importing data from the excel through import set , but the Problem is we need to Place validation for Mandatory fields ,Suppose User forgot to fill Mandatory fields it should give some message or alert to fill those mandatory filled , without filling mandatory filed user should not import the excel, 

How we can achieve this ? 

many thanks for your help! 

[Ankur Bawiskar]

@pramn 

which form is used to upload the excel and start the transformation?

Where are you expecting this validation to run?

[pramn]

We are using Business applications (cmdb) form ,while transforming we can get an validation ?

[Ankur Bawiskar]

@pramn 

anyhow if you create data policy and keep those fields as mandatory during transformation they can see the error as data policy won't allow insert/update if mandatory fields in target are not populated.

If before transformation you want to do then you need to parse the excel and check if the excel cell has value in it