C:\Users\abauman\Documents\Alteryx\Workflows\WeeklyChallenges\Start\challenge_145_start_file\17eofinextractdoc.xls|||`990$`
False
False
Form 990 data dictionary
17eofinextractdoc.xls
Table=`990$`
2+
FirstRow
Warn
C:\Users\abauman\Documents\Alteryx\Workflows\WeeklyChallenges\Start\challenge_145_start_file\17eofinextract990.dat
28591
\s
False
254
False
True
DoubleQuotes
1
Form 990 data by company
17eofinextract990.dat
C:\Users\abauman\Documents\Alteryx\Workflows\WeeklyChallenges\Start\challenge_145_start_file\data-download-pub78.txt
28591
\n
False
254
False
False
DoubleQuotes
1
Company lookup
data-download-pub78.txt
Field_1
Last
Identify fields for analytics
FieldForAnalytics = [Description] = 'Grants to individuals?'
or contains([Descri...
[FieldForAnalytics] = 1
Simple
IsTrue
FieldForAnalytics
True
fixed
2018-12-14 10:52:41
0
2018-12-14 10:52:41
2018-12-14 10:52:41
[FieldForAnalytics] = 1
[State] = "CO"
Simple
=
State
True
fixed
2018-12-14 10:59:45
0
CO
2018-12-14 10:59:45
2018-12-14 10:59:45
[State] = "CO"
Warn
,
EIN - Ascending
tax_pd - Descending
Unique: EIN
Company Name
Company Name
Warning
All
ByName
ShortList = [Grants_to_individuals_]='Y' && [Fundraising_activities_]='Y' &&
[De...
[ShortList] = 1
Simple
IsTrue
ShortList
True
fixed
2018-12-14 11:37:04
0
2018-12-14 11:37:04
2018-12-14 11:37:04
[ShortList] = 1
FundraisingEfficiency - Ascending
RecordID
1
Int32
6
0
C:\Users\abauman\AppData\Local\Temp\Engine_15780_5f7523c1510746d7a00c6a667ed96041_\Engine_21264_6445cfac584049029b8ab52a95843d61_.yxdb
Single
Profile
Horizontal
challenge_145_completed