Active Loans

Requirement | input.xlsx | Solution | End2End(Source Code)

STATUS	LOAN CODE	PAN NUMBER
ACTIVE	SAPTHAGIRI GRAMIN BANK-7325	DIWPK9815G
ACTIVE	ICICI BANK-6673	QISTV8492U
ACTIVE	CENTRAL BANK OF BANK-5652	GTDFR6483T
ACTIVE	UNION BANK OF INDIA-7541	GHAST6432K
ACTIVE	INDIAN BANK-5174	DIWGH9765T
ACTIVE	ICICI BANK-3687	HDGTS5427K
ACTIVE	IDBI-3832	CIWTS8549K
ACTIVE	ICICI BANK-1514	SGTEI7453B
ACTIVE	AXIS BANK-6943	CTRBD5738Y
ACTIVE	CANARA BANK-5132	DIWGK3721P
ACTIVE	SBI-3243	SIKDA9523L
ACTIVE	KOTAK BANK-4553	LDSCT4628C
INACTIVE	LAXMI NIVAS BANK-4392	JSFGT8291K
ACTIVE	HDFC-1545	SAYDG7351J
ACTIVE	SBI-3431	AKLTB3921L
ACTIVE	AXIS BANK-2854	KLERT7451H
ACTIVE	HDFC-8261	LOATY7258D
ACTIVE	CANARA BANK-6294	QISTW9054F
ON HOLD	PUNJAB GRAMIN BANK-5376	RESCT8421B
INACTIVE	KOTAK BANK-9353	FSTEY7638P
ACTIVE	ANDRA BANK-7653	LPEST9640K
ACTIVE	TELANGANA GRAMIN BANK-9524	YDREI6382H
ACTIVE	KOTAK BANK-5114	GTPUE3856E
ON HOLD	AXIS BANK-8723	LPSTA7251A
INACTIVE	ANDRA BANK-3762	RFSBZ5194S
ACTIVE	CANARA BANK-2647	YWQAV4172C
ACTIVE	SYDICATE BANK-4853	LAZTU2819D
ACTIVE	APGVB-1415	SWUTL6217J
ACTIVE	ANDRA BANK-9151	LSTAQ7294X
INACTIVE	CANARA BANK-4935	PECZA7132P
ACTIVE	FEDRAL BANK OF INDIA-4653	PQYXA9061F
ACTIVE	KARNATAKA BANK-3734	UDBMS0261H
ACTIVE	CANARA BANK-6242	HLWOQ7427V
ON HOLD	SBI-2715	BQIST1438G
ACTIVE	BANK OF BARODA-3671	PLSTR8475A
ACTIVE	FEDRAL BANK OF INDIA-5633	GFCNZ8139L
INACTIVE	SYDICATE BANK-6527	GTMPA8501T
ACTIVE	ICICI-2726	FSEZT0643L
ON HOLD	SBI-5146	PDWZY9274Q
ACTIVE	ICICI BANK-1654	FNTWO5914T
INACTIVE	INDIAN BANK-0264	MLKST7535X
ACTIVE	SBI-5014	NYELA0751B
ACTIVE	KERALA GRAMIN BANK-8454	PSVWQ7382U
ON HOLD	CORPORATION BANK-8265	HEZXT8641U
ACTIVE	BANK OF BARODA-5082	JUTXZ8537R
ACTIVE	UNION BANK OF INDIA-5357	FEQCT5281H
ACTIVE	KOTAK BANK-8092	PSTQS7421R
ACTIVE	UCO BANK-8321	DIWSK9817G
INACTIVE	KOTAK BANK-0854	BCMRX5294D
ACTIVE	BANK OF BARODA-5381	YQIST9421G
ON HOLD	KARNATAKA GRAMIN BANK-4361	WUSKA8351V
ACTIVE	SBI-7544	MPGQL8416S
INACTIVE	VIJAYA BANK-7436	GLUEQ9537D
ACTIVE	AXISBANK-8798	PSTEQ5192G
ACTIVE	SYDICATE BANK-2546	WQZCT6128P
ONHOLD	AXIS BANK-4334	STWGH7254T
ACTIVE	AXIS BANK-4153	SEQYR3195P
INACTIVE	UCO BANK-4951	LAQU5419T
ACTIVE	IDBI-7342	PSTQW2841F
ACTIVE	UCO BANK-7461	PSTDW6459E
ACTIVE	CANARA BANK-4294	AQSTF9376H
ACTIVE	CENTRAL BANK OF INDIA-4232	HDXRT7543E
ON HOLD	CANARA BANK-9213	EDSKU6953B
ACTIVE	ANDRA BANK-3413	WXFBS3752S
ACTIVE	SBI-9345	XGRTS9064W
INACTIVE	KOTAK BANK-2273	DXPET7291H
ACTIVE	ANDRA BANK-8421	LPSFT7389C
ACTIVE	BARODA GUJARAT GRAMIN BANK-9721	LYSQE3921M
ACTIVE	SBI-5401	SQWOD7835K
ON HOLD	SAPTAGIRI BANK-5621	XBDTS4794Z
ACTIVE	SBI-7816	LPSFW0638V
ACTIVE	CHAITANYA GODAVARI GARMEENA BANK-4679	ZGREQ8329P
ACTIVE	APGP BANK-0736	ZEWUS1039L
ACTIVE	CORPORATION BANK-1934	PAWHC0421M
ON HOLD	INDIAN BANK-4564	LTRPE9327Z
ACTIVE	SYDICATE BANKs-6497	MJIKS0573D
ACTIVE	AXIS BANK-8591	TXLAQ7294C
ACTIVE	SYDICATE BANK-4394	BHTEW7138F
INACTIVE	UNION BANK OF INDIA-8764	APTQZ4027S
ACTIVE	CANARA BANK-6556	EVTQU7392P
ACTIVE	ICICI BANK-1673	HTFRG4023F
ON HOLD	INDIAN BANK-3716	WXZLO9367T
ACTIVE	CENTRAL BANK OF INDIA-9852	PQAHT6182G
INACTIVE	BANDHANBANK-4471	PDSKU8428M
ACTIVE	APGB-4461	YCFEK1794N
ON HOLD	TELANGANA GRAMIN BANK-4762	PQWZT7283E
ACTIVE	HDFC-5653	UNBWT9317G
INACTIVE	MAHARASTARA BANK-7686	LDTWQ8362I
ACTIVE	SYDICATE BANK-8542	FKECY8732B
ACTIVE	IDBI-5285	YWESR5293L
ACTIVE	UNION BANK OF INDIA-4446	DKPTG7483A
ACTIVE	KOTAK BANK-2945	PQTC8301V
ACTIVE	UCO BANK-3221	SXAPH7294L
ACTIVE	SBI-8266	KLQIF7362Y
ACTIVE	UNION BANK OF BANK-6136	BSGHE9821M
INACTIVE	UNION BANK OF INDIA-1336	NJSED9357T
ACTIVE	CANARA BANK-3135	HSTWU6235J
ON HOLD	CORPORATION BANK-1454	FPOYX5294P
ACTIVE	CENTRAL BANK OF INDIA-6621	WSRGB5291K
ACTIVE	UNION BANK OF INDIA-4685	DECTQ5287K
INACTIVE	HDFC-2922	LYTQP5195D
ACTIVE	ANDRA BANK-1332	PLDTM8510L
ACTIVE	KOTAK BANK-9823	LBJRS7362R