1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
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 = []
|
