🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Multi Line Field Help

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

Let me preface this discussion by saying I am pretty new to the software.  I have reached full exhaustion of ideas when it comes to trying to create the model I am looking for on this report.  The detail field (Failed Reason) encompasses multiple lines but I need each line to be a different row in the table.  In the example below, there would be multiple rows (4, not counting blank rows) for loan number 1234567 and there would be 6 for loan number 1234568.  I have set up the traps seemingly properly to where they are extracting the correct data, but of course all of the lines for detail are combined and regurgitated into a single cell, which does me no good.  From what I can also tell, the TextLine function will not help me either since I'd have to make upwards of 30 formula fields to try and cover the amount of lines there could possibly be in the raw data file.

 

Any help I can get would be much appreciated.  Thank you.

 

From 9/1/2017 - 9/30/2017                

Product                

Consumer Relief               

Loan Number    Loan Type Denial Reasons  Member Number    Amount Approved   Approval Officer  Decision Comments

1234567    PL APPROVED  111111111111 

    

 

     FRAUD WARNING: CREDIT REPORT ALERT SECTION HAS FRAUD KEYWORDS:           

     * ID_MISMATCH           

     Applicant credit score (621) is below the minimum (720)           

     Customer chargeoff period (13) is within: 36 months           

1234568    PL APPROVED  111111111111 

    

 

     Applicant credit score (530) is below the minimum (720)           

     Customer Install Late From Now 120 (34) is over the maximum: 0 instance(s)           

     Customer Install Late From Now 120 Within 1 Yr  (10) is over the maximum: 0 instance(s)           

     Customer collection period (0) is within: 24 months           

     Customer number of collections (4) is greater than 3           

     "Customer collections amount ($3,348.00) is greater than $300.00"

 

Example Desired Data Output:

Loan NumberDateProductFailed Reason
12345679/1/2017Consumer Relief  FRAUD WARNING: CREDIT REPORT ALERT SECTION HAS FRAUD KEYWORDS:
12345679/1/2017Consumer Relief  * ID_MISMATCH      
12345679/1/2017Consumer Relief  Applicant credit score (621) is below the minimum (720)  
12345679/1/2017Consumer Relief 

Customer chargeoff period (13) is within: 36 months 

Find more posts tagged with