# Type NamedTuple has no field id

**URL:** https://discourse.julialang.org/t/type-namedtuple-has-no-field-id/25241
**Category:** New to Julia
**Tags:** juliacomputing, query
**Created:** [June 13, 2019, 11:00am UTC](https://discourse.julialang.org/t/type-namedtuple-has-no-field-id/25241 "2019-06-13T11:00:43Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![shahriariit](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/shahriariit/32/8849_2.png) [@shahriariit](https://discourse.julialang.org/u/shahriariit)
#### Post date: [June 13, 2019, 11:00am UTC](https://discourse.julialang.org/t/type-namedtuple-has-no-field-id/25241/1 "2019-06-13T11:00:43Z")

</div>

I try to run this code,

```julia
s2_obj = @from i in df_recipe begin
@let ibu_cs = (i.ibu - cs_dict["m_ibu"]) / cs_dict["sd_ibu"]
@let color_cs = (i.color - cs_dict["m_color"]) / cs_dict["sd_color"]
@select {id = i.id, ibu = ibu_cs, color = color_cs}
@collect DataFrame
end

```

But get this error

```julia
type NamedTuple has no field id

Stacktrace:
 [1] getproperty(::Any, ::Symbol) at ./sysimg.jl:18
 [2] (::getfield(Main, Symbol("##24#27")))(::NamedTuple{(Symbol("##t#362"), :color_cs),Tuple{NamedTuple{(:i, :ibu_cs),Tuple{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{DataValues.DataValue{Int64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Int64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String}}},DataValues.DataValue{Float64}}},DataValues.DataValue{Float64}}}) at ./none:0
 [3] iterate at /home/jrun/.julia/packages/QueryOperators/OFi0k/src/enumerable/enumerable_map.jl:25 [inlined]
 [4] iterate at /home/jrun/.julia/packages/Tables/8f4rT/src/iteratorwrapper.jl:38 [inlined]
 [5] buildcolumns at /home/jrun/.julia/packages/Tables/8f4rT/src/fallbacks.jl:123 [inlined]
 [6] columns at /home/jrun/.julia/packages/Tables/8f4rT/src/fallbacks.jl:149 [inlined]
 [7] columns at /home/jrun/.julia/packages/Tables/8f4rT/src/fallbacks.jl:153 [inlined]
 [8] DataFrame(::QueryOperators.EnumerableMap{Union{},QueryOperators.EnumerableMap{NamedTuple{(Symbol("##t#362"), :color_cs),Tuple{NamedTuple{(:i, :ibu_cs),Tuple{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{DataValues.DataValue{Int64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Int64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String}}},DataValues.DataValue{Float64}}},DataValues.DataValue{Float64}}},QueryOperators.EnumerableMap{NamedTuple{(:i, :ibu_cs),Tuple{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{DataValues.DataValue{Int64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Int64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String}}},DataValues.DataValue{Float64}}},QueryOperators.EnumerableIterable{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{DataValues.DataValue{Int64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Int64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String}}},Tables.DataValueRowIterator{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{DataValues.DataValue{Int64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Int64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String},DataValues.DataValue{Float64},DataValues.DataValue{Float64},DataValues.DataValue{String},DataValues.DataValue{String}}},Array{NamedTuple{(:beer_id, :name, :url, :style, :style_id, :size, :og, :fg, :abv, :ibu, :color, :boil_size, :boil_time, :biol_grav, :efficiency, :mash_thick, :sugar_scale, :brew_method, :pitch_rate, :pri_temp, :prime_method, :prime_am),Tuple{Union{Missing, Int64},Union{Missing, String},Union{Missing, String},Union{Missing, String},Union{Missing, Int64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, String},Union{Missing, String},Union{Missing, Float64},Union{Missing, Float64},Union{Missing, String},Union{Missing, String}}},1}}},getfield(Main, Symbol("##22#25"))},getfield(Main, Symbol("##23#26"))},getfield(Main, Symbol("##24#27"))}) at /home/jrun/.julia/packages/DataFrames/IKMvt/src/other/tables.jl:21
 [9] top-level scope at In[16]:1

```

How can I solve it.

---

<div class="post-metadata">

### Author: ![Tamas\_Papp](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tamas_papp/32/25949_2.png) [@Tamas\_Papp](https://discourse.julialang.org/u/Tamas_Papp)
#### Post date: [June 13, 2019, 12:20pm UTC](https://discourse.julialang.org/t/type-namedtuple-has-no-field-id/25241/2 "2019-06-13T12:20:50Z")

</div>

Are you sure that `df_recipe` has an `id` column? Please post a self-contained example.

> [@Please read: make it easier to help you](https://discourse.julialang.org/t/psa-make-it-easier-to-help-you/14757):
>
> Welcome to the Julia Discourse! We are enthusiastic about helping Julia programmers, both beginner and experienced. This public service announcement (PSA) outlines best practices when asking for help. Following these points makes it easier for us to help you and more likely you’ll get a prompt, useful answer. Keywords are highlighted to make it easier to refer to specific points. Choose a descriptive title that captures the key part of your question, eg “plots with multiple axes” instead of …

---

<div class="post-metadata">

### Author: ![shahriariit](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/shahriariit/32/8849_2.png) [@shahriariit](https://discourse.julialang.org/u/shahriariit)
#### Post date: [June 13, 2019, 12:42pm UTC](https://discourse.julialang.org/t/type-namedtuple-has-no-field-id/25241/3 "2019-06-13T12:42:32Z")

</div>

ok, thanks. i can solve it.