Script Issue

[upaliwije]

Hi friends;

I attach herewith My Qv Document and suppoting excel sheet. My output Pivot talbe is as follows

POLICY_NO	POLICY_YEAR	PERIOD_TO	ISSUE_DATE	I_DATE	C_DATE	CAN_DATE	GROSS_PREMIUM	REFUNDS
NM00071H000001	07	21-04-17	20-04-16	20/4/2016	-	-	11,696	0
NM00071H000001	07	21-04-17	-	-	30/4/2016	NA	0	-11,696
NM00141D0000238	14	25-03-17	25-03-16	25/3/2016	-	20/4/2016	13,934	0
NM00141D0000238	14	25-03-17	-	-	20/4/2016	NA	0	-13,934

In the above table CAN_DATE is blank in the very first row where as it should appear like in row number 3. Pls check my document and advise me how to correct it.

[kaushiknsolanki]

Hi,

Change below code:

cdate:

Mapping load trim(POLICY_NO),trim(C_DATE)

Resident tmp;

Add where condition as below.

cdate:

Mapping load trim(POLICY_NO),trim(C_DATE)

Resident tmp where not IsNull(C_DATE) ;

Regards,

Kaushik Solanki

[upaliwije]

Can my expert friends pls give an advice ?

[kaushiknsolanki]

Hi,

Did you try the script I gave you in above post?

Regards,

Kaushik Solanki

[upaliwije]

Sorry,

I ll try and come back to you

[upaliwije]

Hi Solanki

Thanks for your advice. It is working for the sample I sent you. But when I applied it to my whole data one reord does not give the answer. I attched my excel sheet with new record. Kindly see to it and advise me pls.

[kaushiknsolanki · Accepted solution]

Hi,

It does work.

Have a look at the attached application.

Regards,

Kaushik Solanki

[upaliwije]

Yes Solanki It is working. But I add some more script some fields are blank. Eg NUMDA, AGE

Kinldy have a look at the attachment and correct me.

[upaliwije]

Sorry I made a mistake. Your earlier reply is perfect