Input
Output
C:\Users\JORDAN~1\AppData\Local\Temp\Engine_12652_f9efdcc801c0468ea2edd656537c9b18_\Engine_13596_eacbc3c5635e49b59ed41ef98d3db575_.yxdb
Single
Profile
C:\Users\JORDAN~1\AppData\Local\Temp\Engine_12652_f9efdcc801c0468ea2edd656537c9b18_\Engine_13596_b97f8aa0dc8b4dd69ae39e4afab922c4_.yxdb
\\AU-SYDFIL001\AssuranceData2\Assurance\Non - Client\Assurance\Data Assurance\4_Resources\Alteryx\Alteryx Challenges\Challenge 036 - Int - Data Parsing\challenge_36_start_file\pubmed_result.txt
Unset
Unset
Unset
28591
Unset
pubmed_result.txt
\\AU-SYDFIL001\AssuranceData2\Assurance\Non - Client\Assurance\Data Assurance\4_Resources\Alteryx\Alteryx Challenges\Challenge 036 - Int - Data Parsing\challenge_36_start_file\Result.yxdb
Result.yxdb
Field_1
ParseComplex
Warn
Field_1_Matched
Parse out PMID and author flags
Parse:
\|(.*)
Replace PMID and FAU references with a pipe in preparation for cleansing
Field_1 = Replace([Field_1], "PMID- ", "|")
Field_1 = Replace([Field_1], "FAU - ...
Remove extraneous field
!IsNull([RegExOut1])
Simple
IsNotNull
RegExOut1
True
fixed
2019-09-17 21:16:36
0
2019-09-17 21:16:36
2019-09-17 21:16:36
!IsNull([RegExOut1])
Create PMID field
PMID
New Field
Int32
4
Empty
IF [PMID]=""
THEN [ROW-1:PMID]
ELSE [PMID]
ENDIF
Fill PMID field
IF [PMID]=""
THEN [ROW-1:PMID]
ELSE [PMID]
ENDIF
Create Author Names Field
/
Concatenate
Author Names
Author
Last
Author
Split out
Concatenated
Author Names
C:\Users\JORDAN~1\AppData\Local\Temp\Engine_12652_f9efdcc801c0468ea2edd656537c9b18_\Engine_13596_1288ebb03dac421d8598cbfe53b3e4cc_.yxdb
Single
Profile
,
Cross Tab to List out
Author Names
!IsNull([Value])
Simple
IsNotNull
Value
True
fixed
2019-09-19 19:11:18
0
2019-09-19 19:11:18
2019-09-19 19:11:18
!IsNull([Value])
Create Author Number Field
Warn
Transpose in readiness
to filter out Nulls
!IsEmpty([Author Names])
Simple
IsNotEmpty
Author Names
True
fixed
2019-09-19 19:27:21
0
2019-09-19 19:27:21
2019-09-19 19:27:21
Filter out Nulls
!IsEmpty([Author Names])
Horizontal
challenge_36_JP_solution