C:\Users\dduong\AppData\Local\Temp\Engine_10812_bd10ca26a55e4606a118b79abf8ae340_\Engine_17560_7bab8fead57649aeb69ef090ab8f875d_.yxdb
Single
Profile
ZZZZ UDRC Report Example Report Date: 02-JUN-2019 20:30:00
Application GL Date From : 01-APR-2019
-------------------- -------- -----------
Customer Billing/Invoice Related Transaction in Transaction Allocated Earned Unearned Total Amount In
Number Customer Batch Number Customer Receipt Number Currency Currency Receipt Amount Discount Discount Functional Currency
--------- -------------------- ---------- --------------- ---------- --------------- ----------- --------------- --------------- ---------- ---------- --------------------
P290 AUDE 06-MAY-2019
"12345678 FAKEF IN22222222 10019777 NON OP(12345) USD 1,220.10 11,022.88 0 0 1,170.10 "
"23456789 AKEF IN33333333 10007999 NON OP(12345) USD 122.40 1,222.74 0 0 132.40 "
"34567890 AK IN4444444 10007999 NON OP(12345) USD 1,222.00 11,222.00 0 0 1,230.00 "
Get rows contain data
21-23
RecordID
1
Int32
6
0
Get rows contain column headers
16-18
RecordID
1
Int32
6
0
RightInputRows
Warn
Mapped
ColumnNumber
Concat_ExtractedWord
C:\Users\dduong\AppData\Local\Temp\Engine_10812_bd10ca26a55e4606a118b79abf8ae340_\Engine_17560_db3e544d661e4c81a6488a47b225d7c4_.yxdb
Single
Profile
C:\Users\dduong\AppData\Local\Temp\Engine_10812_bd10ca26a55e4606a118b79abf8ae340_\Engine_17560_cfe415b9d2e947cd9436d2a03f1b4175_.yxdb
Single
Profile
Get column headers
Error
False
False
"Original Data","WordStart","Wordlength","ExtractedWord"
False
False
True
True
False
False
False
False
False
upper
ColumnNumber
ColumnNumber
Int16
2
Empty
if [Row-1:RecordID] = [RecordID]
then [Row-1:ColumnNumber]+1
else 1
endif
if [Row-1:RecordID] = [RecordID]
then [Row-1:ColumnNumber]+1
...
RecordID - Ascending
Original Data - Ascending
WordStart - Ascending
Wordlength - Ascending
,
Get column headers
Error
False
False
"Original Data","WordStart","Wordlength","ExtractedWord"
False
False
True
True
False
False
False
False
False
upper
ColumnNumber
ColumnNumber
Int16
2
Empty
if [Row-1:RecordID] = [RecordID]
then [Row-1:ColumnNumber]+1
else 1
endif
if [Row-1:RecordID] = [RecordID]
then [Row-1:ColumnNumber]+1
...
RecordID - Ascending
Original Data - Ascending
WordStart - Ascending
Wordlength - Ascending
False
False
"ColumnNumber","Concat_ExtractedWord"
False
False
True
True
False
False
False
False
False
upper
\s
RecordID - Ascending
ExtractedWord - Ascending
Get positions of column headers and value
19
Original Data
Replace
Original Data
Warn
Original Data_Matched
Original Data
HeaderNameStart
WordStart
Int32
4
Empty
if [Row-1:Wordlength] = 0 then 0 else [Row-1:WordStart]+[Row-1:Wordlength]+2 endif
if [Row-1:Wordlength] = 0 then 0 else [Row-1:WordStart]+[Row-...
Part 1
14
Original Data
ParseComplex
Original Data
Warn
Original Data_Matched
20
Original Data
Last
F
True
True
"Original Data"
False
False
True
True
False
False
False
False
False
upper
Warning
All
ByName
FirstRow
Warn
Horizontal
challenge_262_DD