topic aggre() between null and value in App Development

aggre() between null and value

abedalraheem — Mon, 18 Nov 2019 09:56:09 GMT

Hi every body

I have the below data in my database :

policy No	Endorsement No
P1
P1	E1
P2
P2	E1
P3

and I want to load it to be like the below table , means if there is a value for P1 take it if not put it as null .

Policy No	Endorsement No
P1	E1
P2	E1
P3

I tried to use Only function but it does not work with me , any one faced this before .

appreciate your help .

Re: aggre() between null and value

sunny_talwar — Mon, 18 Nov 2019 12:10:11 GMT

May be try this

Table: LOAD [policy No], MaxString(If(Len(Trim([Endorsement No])) > 0, [Endorsement No])) as [Endorsement No] Group By [policy No]; LOAD * INLINE [ policy No, Endorsement No P1, P1, E1 P2, P2, E1 P3, ];

I used If statement to make sure that Endorsement No was forced to be null as I was loading it from an Inline table... but if you have true nulls coming from your source data... MaxString([Endorsement No]) should work for you....