Hi

 

I've been asked if Pyramid can replicate a report a team currently have. 

 

The report has some summary information, and then some comments which the underwriter would input. I said they can't input claims so they suggested I could manufacture the comment using data within the system. So I created a column which concatenates several key fields, but these fields can also have multiple rows. 

 

In SQL i can use STUFF to combine the multiple rows into a single column, and I can add line breaks using Char(13)+Char(10) but I was wondering how that would appear in Pyramid as a column i.e. would it recognise that these a line a break, and in the table drop a line for each line break. I would want it to have a new row , as its just comments relating to one row of data.

 

So for example a column like this: 1. Claim 1 - Incurred Value $200k - Loss due to negligence. 2. Claim 2 - Incurred Value $250k - Loss due to Storm. 3. Claim 3.... and so on? 

 

would appear like this 

1. Claim 1 - Incurred Value $200k - Loss due to negligence.

2. Claim 2 - Incurred Value $250k - Loss due to Storm.

3. Claim 3.

 

Would this work natively or would I need to do anything prior to going into model?

 

Thanks

 

Nick