C:\Users\Erica Hughes\Downloads\17eofinextractdoc.xls|||`990$`
False
False
17eofinextractdoc.xls
Query=`990$`
C:\Users\Erica Hughes\Downloads\17eofinextract990.dat
Unset
Unset
Unset
28591
Unset
17eofinextract990.dat
C:\Users\Erica Hughes\Downloads\data-download-pub78.txt
Unset
Unset
Unset
28591
Unset
data-download-pub78.txt
Field_1
Last
Simple
IsNotEmpty
Field_1
True
fixed
2020-07-31 08:26:00
0
2020-07-31 08:26:00
2020-07-31 08:26:00
Filter out empty rows
!IsEmpty([Field_1])
Simple
IsNotNull
F2
True
fixed
2020-07-31 08:27:29
0
2020-07-31 08:27:29
2020-07-31 08:27:29
Filter out Null row
!IsNull([F2])
False
True
"F2"
False
False
True
False
False
False
False
False
False
upper
Remove Null Column
Remove Null Column
Field_1
Last
FirstRow
Warn
Rename Fields using first row
Rename Fields using first row
Change Field Headers
Change Field Headers
Simple
=
State
True
fixed
2020-07-31 08:37:58
0
CO
2020-07-31 08:37:58
2020-07-31 08:37:58
Filter to get CO state only
[State] = "CO"
RightInputRows
Warn
Mapped
Data Items on Form 990 Annual Masterfile Extract
F2
Rename Fields using column from L input
Bring fields to top for sense check
Bring fields to top for sense check
[Grants to individuals?] = "Y"
AND [Fundraising activities?] = "Y"
AND [Deductible non-cash contributions?] = "Y"
AND [Number of employees]<300
AND [Advertising and promotion]<1000
AND [Total contributions]>5000000
Custom
Filter by criteria in challenge
[Grants to individuals?] = "Y"
AND [Fundraising activities?] = "Y"
AND [Deductib...
Change data types
Change data types
Join on EIN
Join on EIN
Sort Ascending
Fundraising Efficiency - Ascending
Horizontal
challenge_145_start