REPORT IS *NOT* A TABLE: parse out the raw text, removing HTML and CSS
REPORT IS A TABLE: parse out the values into an Alteryx datastream
Report
cell
Report
datatable
datatable_OuterXML
td
,
cell=trim([cell])
class=trim([class])
cell
row
Int32
254
Empty
IIF(left([class],7)=='column0', [Row-1:row]+1,[Row-1:row])
IIF(left([class],7)=='column0', [Row-1:row]+1,[Row-1:row])
RightInputRows
Warn
Positional
td
C:\ProgramData\Alteryx\Engine\Engine_24568_9e053e833f614049acfd20b706102bfd\Engine_26744_07a295d1b14046958b7f48fc30120b01.yxdb
Single
Table
Input26
..\..\_externals\1\GetTableFromReport.TestData.yxdb
GetTableFromReport.TestData.yxdb
Output29
Ignore
All
ByName
Ignore
All
ByName
Ignore
All
ByName
#1
#2
5
Get the names of the columns in the table
=0
]]>
Custom
Does the report contain a table?
=0
]]>
Report=regex_replace(regex_replace(
regex_replace(
regex_r...
Report
Ignore
All
ByName
Ignore
All
ByName
#1
#2
__placeholder__
Ignore
All
ByName
#1
#2
1
Y
Get the actual data values out of the table
Formula
[Type]!="Byte"
[__placeholder__]!='Y'
Custom
[__placeholder__]!='Y'
Alteryx Macro:
Get Table From Report
Module Description
Horizontal
Question
Macro Input (26)
Question
Numeric Up Down (27)
Question
Macro Output (29)
GetTableFromReport
NoCondition
(Always Run)
UpdateValue
Simple
4/Value
Tab
Questions
Tab (25)
MacroInput
Macro Input (26)
Macro Input (26)
NumericUpDown
Pick record number that contains table
Numeric Up Down (27)
MacroOutput
Macro Output (29)
Macro Output (29)
Macro