aboutsummaryrefslogtreecommitdiff
path: root/examples/example_csv.toml
blob: 1374515f3eb6789cd9910bc5baac20d1e9fcd728 (plain)
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
version = 1

[source]
  file = "importer.csv"
  name = "source"

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

[externals.a_financial]
  intern_key = ":target.A"
  extern_key = ":O"
  file = "financial.xlsx"
  allow_missing = false

[sheet]
  columns = [
    ":A",
   "concat(\"-\", :A, :target.E, :B)", 
   ":C", 
   """counter(
    [:C],
    [:A])""",
   ":E", 
   "match(\"\\(..\\)\", :B)", 
   ":D", 
   "counter([:D] ,[:A])"
  ]
  filters = []
  sort = []
  uniq = []