version = 1

[source]
  file = "financial.xlsx"
  name = "source"

[externals.target]
  intern_key = ":source.A ^ '-suffix'"
  extern_key = ":A ^ '-suffix'"
  file = "financial.xlsx"
  allow_missing = false

[externals.a_financial]
  intern_key = ":target.A"
  extern_key = ":O" # This key is here to generate errors
  file = "financial.xlsx"
  allow_missing = false

[sheet]
  columns = [
    ":target.A ^ '\\''",  # Ensure the quote is escaped before sending to the sql engine
    "concat('-', :A, :target.E, :B)",
    ":C",
    "counter([:C], [:A])", 
    "sum(:F, [:B, :C, :D], [:B])",
    "int(1) = counter([:C], [:A])", 
    ":E", "match('(..)', :B)",
    ":D",
    "counter([:D], [:A])",
    "year(:N)",
    # Apply a function on the year
    """:Q 
        - 
        # We only keep the years after Y2K
        2000"""

  ]
  filters = [

    "1 = counter( [:B], [:A])",

  ]
  sort = []
  uniq = []