C:\Users\jchou\Downloads\alteryx Community Example.xlsx|||`Sheet1$`
False
1
alteryx Community Example.xlsx
Table=`Sheet1$`
FirstRow
Warn
Take column name from first row for F4 and F5
Component ID and Component Name
Warn
Key Columns = First 6 Columns
Data = Remaining
Unique list of Dates
REGEX_Match([Name], "\d{4}-\d{2}-\d{2}")
Custom
IsNotNull
Value
True
fixed
2019-11-01 23:49:48
0
2019-11-01 23:49:48
2019-11-01 23:49:48
Filter to rows with date formats in [Name]
REGEX_Match([Name], "\d{4}-\d{2}-\d{2}")
REGEX_Match([Name], "\d{4}-\d{2}-\d{2}")
Join on Name (aka Date)
,
Group Data by first 6 columns
Column Header = Name
Column Value = Value
Formula
Replace([_CurrentField_],"_", "/")
[Name]<=DateTimeToday()
Custom
=
True
fixed
2019-11-01 23:59:50
0
2019-11-01 23:59:50
2019-11-01 23:59:50
Filter out any future dates
[Name]<=DateTimeToday()
[Name]<=DateTimeToday()
Max [Name] = Date
Datatype: Date
Change to String for Join
Horizontal
Jqmes_data manipulation from excel file