.\Data Example for Alteryx Community.txt
28591
\n
False
1000
False
False
DoubleQuotes
1
Data Example for Alteryx Community.txt
Skip
29
Skip 1st 29
Field_1
Replace
Warn
Field_1_Matched
Replace:
\s{2,}
|
RecordID
1
Int32
6
0
[RecordID] <= 2
Simple
<=
RecordID
True
fixed
2019-01-16 12:43:45
0
2
2019-01-16 12:43:45
2019-01-16 12:43:45
[RecordID] <= 2
Warning
All
ByName
RecordID - Ascending
C:\Users\danilang\AppData\Local\Temp\1\Engine_13608_56ccf7fb68d945c7b3be6708e576f016_\Engine_8076_b2c7e7363ef740a289088375de41e7fd_.yxdb
Single
Profile
!IsNull([Current])
Simple
IsNotNull
Current
True
fixed
2019-01-17 07:21:59
0
2019-01-17 07:21:59
2019-01-17 07:21:59
!IsNull([Current])
All companies row
Startswith([Field_1],"All")
Custom
=
Field_1
True
fixed
2019-01-17 06:52:10
0
2019-01-17 06:52:10
2019-01-17 06:52:10
Startswith([Field_1],"All")
Field_1
Last
Warning
All
ByPos
Percent rows
Custom
=
Field_1
True
fixed
2019-01-16 14:52:25
0
2019-01-16 14:52:25
2019-01-16 14:52:25
Percent rows
Field_1
Last
Warning
All
ByPos
Value rows
mod([RecordID],3) = 1 and ! startswith([Field_1],"|") and ! startswith([Field_1],"All")
Custom
=
Field_1
True
fixed
2019-01-16 14:52:25
0
2019-01-16 14:52:25
2019-01-16 14:52:25
value rows
mod([RecordID],3) = 1 and ! startswith([Field_1],"|") and ! startswith([Field_1]...
Field_1
Last
Warning
All
ByPos
Header Rows
[RecordID] = 1
Simple
=
RecordID
True
fixed
2019-01-16 12:45:13
0
1
2019-01-16 12:45:13
2019-01-16 12:45:13
[RecordID] = 1
Field_1 = "| | | | " +[Field_1]
Field_1 = Left([Field_1], findstring([Field_1],"...
Warning
All
ByName
#1
#2
Field_1
Last
Warn
Name - Ascending
RecordID - Ascending
"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17"
True
True
True
False
False
False
False
False
False
upper
FirstRow
Warn
Horizontal
Alteryx Community Example Workflow v2