diff options
author | Sébastien Dailly <sebastien@dailly.me> | 2024-03-14 08:26:58 +0100 |
---|---|---|
committer | Sébastien Dailly <sebastien@dailly.me> | 2024-03-14 08:26:58 +0100 |
commit | 6b377719c10d5ab3343fd5221f99a4a21008e25a (patch) | |
tree | a7c1e9a820d339a2f161af3e09cf9e3161286796 /examples/example_csv.toml |
Initial commitmain
Diffstat (limited to 'examples/example_csv.toml')
-rw-r--r-- | examples/example_csv.toml | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/examples/example_csv.toml b/examples/example_csv.toml new file mode 100644 index 0000000..1374515 --- /dev/null +++ b/examples/example_csv.toml @@ -0,0 +1,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 = [] |