concertInfo_OuterXML
worksInfo_OuterXML
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_6281c560f9644419a1b9ab119d64595f_.yxdb
Single
Profile
worksInfo_OuterXML
soloists_OuterXML
[Soloists] != ", ()"
Simple
!=
Soloists
True
fixed
2018-05-13 21:30:04
0
, ()
2018-05-13 21:30:04
2018-05-13 21:30:04
[Soloists] != ", ()"
Unique: programID, ID, orchestra, season, concertInfo2, Location, Venue, Date, Time, movement, Soloists
ByName
Warning
All
ManualDelayed
#1
#2
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_c4acad8ba3eb4e7282998646d05cb7f9_.yxdb
Single
Profile
https://raw.githubusercontent.com/nyphilarchive/PerformanceHistory/master/Programs/xml/2011-12_TO_NOW.xml
Field1
String
65001
GET
Compose
2
600
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_a517d99911494dd4ba8c14625f2e661f_.yxdb
Single
Profile
DownloadData
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_29e5819b88654a3f84621fdbbfab4559_.yxdb
Single
Profile
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_a7437389b7f74f56bc95b324b4ea27dd_.yxdb
Single
Profile
Date
yyyy-MM-dd
Performance Date
Convert Date From:
yyyy-MM-dd
programID - Ascending
Performance Date - Ascending
C:\ProgramData\Alteryx\Engine\Engine_2724_4ef5b0132ea04de29fe9be799598e89b_\Engine_6612_54f1d9c59ff7493a9dacd31683e499f8_.yxdb
Single
Profile
Unique: Program ID
[interval] != "intermission"
Simple
!=
interval
True
fixed
2018-05-14 13:19:30
0
intermission
2018-05-14 13:19:30
2018-05-14 13:19:30
[interval] != "intermission"
Horizontal
challenge_116_solution