Multi Line Field Help
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 Number | Date | Product | Failed Reason |
---|---|---|---|
1234567 | 9/1/2017 | Consumer Relief | FRAUD WARNING: CREDIT REPORT ALERT SECTION HAS FRAUD KEYWORDS: |
1234567 | 9/1/2017 | Consumer Relief | * ID_MISMATCH |
1234567 | 9/1/2017 | Consumer Relief | Applicant credit score (621) is below the minimum (720) |
1234567 | 9/1/2017 | Consumer Relief | Customer chargeoff period (13) is within: 36 months |