Ramakrishnan R - 2017-06-22

Hi,

If I have a text file that contains different record types as described below, how can I import the file and create a schema for it? Please help me.

EMP,123-1234-123,John Petit,19891110,New York
ELECTION,Medical,EMP,Cigna
ELECTION,Dental,EMP,Delta
ELECTION,Vision,EMP,VSP
EMP,123-123-1235,James Sanders,19791110,Utta
ELECTION,Medical,ESP,Cigna
ELECTION,Dental,ESP,Delta
ELECTION,Vision,ESP,VSP

If you notice the above text file, it contains two different records such as EMP and ELECTION. Both record types have different field structures. Please guide me how can I validate these kinds of files.

Thanks in advance.