W:\Program Files (x86)\Alteryx\DataProducts\Portfolio\ALTERYX_US_Experian_16B_16B\Help\Documentation\Q4 2016 Change Log.xlsx|||<List of Sheet Names>
False
1
Q4 2016 Change Log.xlsx
Table=<List of Sheet Names>
Output7
o
')+"'"+[Sheet Names]+"$'"
]]>
This macro takes the FullPath field (XLSX file and directory) and updates the Input Data tool. The Input Data tool outputs the list of sheet names from the current Excel file. It also outputs the Full Path as an additional field.
A Formula tool then builds the string of FullPath+Table/Sheet name. Notice that it also adds a "$" to the end of complete string. The Select tool removes everything except the constructed string from the Formula tool and is then fed into the next macro.
CombineSheets (12)
Horizontal
Question
ControlParam.Control Parameter (4)
Question
Macro Output (7)
ReadSheetPaths
NoCondition
(Always Run)
UpdateValue
Simple
W:\Program Files (x86)\Alteryx\DataProducts\Portfolio\ALTERYX_US_Experian_16B_16B\Help\Documentation\Q4 2016 Change Log.xlsx
1/File
Tab
Questions
Tab (3)
ControlParam
Control Parameter (4)
Control Parameter (4)
MacroOutput
Macro Output (7)
Macro Output (7)
Macro
AutoByName
Control Parameter (4)
Control Parameter (4)