Fundraising_Efficiency = tonumber([Fundraising expenses])/tonumber([Total contri...
Fundraising_Efficiency - Ascending
Prep data on charities
https://www.irs.gov/pub/irs-soi/17eofinextract990.dat
Download 2017 data
Field1
String
65001
GET
Compose
2
600
DownloadData
parse to
rows
DownloadData
Last
DownloadData
parse to
columns
https://s3-us-west-1.amazonaws.com/ayx.community.assets/17eofinextractdoc.xls
Download headings
URL_Dictionary
SpecificFile
Path
GET
Compose
2
600
Path = [Engine.TempFilePath]+right([URL_Dictionary],findstring(ReverseString([UR...
C:\Program Files (x86)\Alteryx\Engine\Engine_4580_a4588934f0034c2b9d49b1f03d4d1bd6_\17eofinextractdoc.xls|||`990$`
False
False
ModifySQL
Path
C:\Program Files (x86)\Alteryx\Engine\Engine_4580_a4588934f0034c2b9d49b1f03d4d1bd6_\17eofinextractdoc.xls
RightInputRows
Warn
Mapped
Data Items on Form 990 Annual Masterfile Extract
F2
rename columns
FirstRow
Warn
5000000
]]>
Custom
=
Grants to individuals?
True
fixed
2018-12-10 20:11:34
0
Y
2018-12-10 20:11:34
2018-12-10 20:11:34
Filter for valid charities
[Grants to individuals?] = "Y"
AND
[Fundraising activities?]="Y"
AND
[Deductible...
IRS Lookup download, parse, filter
DownloadData
parse to rows
DownloadData
Last
DownloadData
!IsEmpty([DownloadData])
AND
[DownloadData4]="CO"
Custom
IsNotEmpty
DownloadData
True
fixed
2018-12-10 19:50:02
0
2018-12-10 19:50:02
2018-12-10 19:50:02
Filter for CO
!IsEmpty([DownloadData])
AND
[DownloadData4]="CO"
https://s3-us-west-1.amazonaws.com/ayx.community.assets/data-download-pub78.txt
URL
String
65001
GET
Compose
2
600
rename fields
Horizontal
Santalytics2018_01_EHB