1 files changed, 44 insertions, 0 deletions
diff --git a/examples/importer.toml b/examples/importer.toml
new file mode 100644
index 0000000..4be6618
--- /dev/null
+++ b/examples/importer.toml
@@ -0,0 +1,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 = []