https://raw.githubusercontent.com/nyphilarchive/PerformanceHistory/master/Programs/xml/2011-12_TO_NOW.xml
Field1
String
65001
GET
Compose
2
600
DownloadData
Value
Warn
!IsNull([Value])
Simple
IsNotNull
Value
True
fixed
2019-08-13 16:25:09
0
2019-08-13 16:25:09
2019-08-13 16:25:09
!IsNull([Value])
worksInfo_OuterXML
soloists_OuterXML
[interval] != "Intermission"
Simple
!=
interval
True
fixed
2019-08-13 16:40:56
0
Intermission
2019-08-13 16:40:56
2019-08-13 16:40:56
[interval] != "Intermission"
!IsNull([soloistName])
Simple
IsNotNull
soloistName
True
fixed
2019-08-13 16:53:10
0
2019-08-13 16:53:10
2019-08-13 16:53:10
!IsNull([soloistName])
Program ID - Ascending
Performance Date - Ascending
C:\ProgramData\Alteryx\Engine\Engine_2672_95f0253ea0a146efab487d8dc0b13913_\Engine_1776_692ca68bc55d4997b9b43fb2f8eb3b18_.yxdb
Single
Profile
download data
parse step 1
select fields
select fields
transpose concertinfo 1-5
keep only records with concertinfo
parse concertinfo
select fields
parse date
parse worksinfo
exclude "Intermission"
select fields
parse solists
keep only records with solist info
concatenate solist and instrument
create solists list
select fields
join solists
sort by program and date
keep first date only
Horizontal
challenge_116_solution_rsc