diff options
| author | Sébastien Dailly <sebastien@dailly.me> | 2025-03-13 20:17:51 +0100 |
|---|---|---|
| committer | Sébastien Dailly <sebastien@dailly.me> | 2025-04-08 18:39:49 +0200 |
| commit | 9e2dbe43abe97c4e60b158e5fa52172468a2afb8 (patch) | |
| tree | f58276e500d8ab0b84cdf74cc36fc73d4bca3892 /examples/importer.toml | |
| parent | 0bdc640331b903532fb345930e7078752ba54a2d (diff) | |
Declare the files to load from an external configuration file
Diffstat (limited to 'examples/importer.toml')
| -rw-r--r-- | examples/importer.toml | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/examples/importer.toml b/examples/importer.toml index 08e9e25..a8ee199 100644 --- a/examples/importer.toml +++ b/examples/importer.toml @@ -1,23 +1,25 @@ +dataset = "dataset.toml" + [source] - file = "financial.xlsx" name = "source" + # The file is looked up in the dataset -[externals.target] +[externals.source-target] intern_key = ":source.A ^ '-suffix'" extern_key = ":A ^ '-suffix'" - file = "financial.xlsx" allow_missing = false + # The file is looked up in the dataset [externals.a_financial] - intern_key = ":target.A" - extern_key = ":O" # This key is here to generate errors + intern_key = ":source-target.A" + extern_key = ":O" file = "financial.xlsx" allow_missing = false [sheet] columns = [ - ":target.A ^ '\\''", # Ensure the quote is escaped before sending to the sql engine - "join('-', :A, :target.E, :B)", + ":source-target.A ^ '\\''", # Ensure the quote is escaped before sending to the sql engine + "join('-', :A, :source-target.E, :B)", ":C", "counter([:C], [:A])", "sum(:F, [:B, :C, :D], [:B])", @@ -40,4 +42,3 @@ ] sort = [] - uniq = [] |