Hello,
Can I use multiple joins with different tables?
Are there any limitations?
Please add the functionality to upload existing tables from .xls Excel files. It will save tons of time.
2個讚
I saw that the latest n8n release mentions the new Data Tables feature. I upgraded and installed the new version locally, but I’m not seeing this feature in my setup.
-
Installed version: 1.112.4
-
Installation method: desktop app
-
Environment: Windows
Am I missing something? Do I need to enable Data Tables manually, or is it available only in certain plans or environments?
Thanks in advance for your help!
Right now data tables are only in the beta version, 1.113.1. It’s not a stable version yet, so it won’t be available via normal docker installation methods, though I assume you could specify the specific version to pull it–but “latest” won’t pull the beta until they move it to stable.
The latest version with data tables is 1.113.2 as of a couple of hours ago.
You can pull it with the following tags:
- next
- beta
- 1.113.2
1個讚
@Niklas_Hatje I’m still testing it out but it definitely looks promising.
Regarding #4, Liam McGarrigle also responded to me on reddit that #4 was done on purpose. While I understand the idea behind it to make numbers “easier” to read, may I suggest being able to configure it(for example to be 123_12_1234, 12_123_123, etc. in the settings) or be able to turn it off completely? If we need to troubleshoot issues, for example, spaces being inserted in between numbers within the data/rows, that feature will make it very difficult when looking at the data on the tables themselves.
2個讚
Welcome to the community!
You can make an import workflow for this. It would just be two nodes 
At this point, there is no SQL like queries like join or any working across tables.
Anything like that will need to use workflow logic and multiple reads to do anything “more advanced”
1個讚
Interesting development.
Where is the data stored? What file/folder? A new SQLite file?
Or is it just stored in the default database.sqlite file?
Awesome! I cant wait to start using it. When will it be rolled out? I cant seem to find it in my instance.
You got it, it’s stored in the same db you setup n8n with, so that same sqlite db or postgres
Its really useful
thanks
Thanks @liam! Quick follow up if I may:
-
For “casual”, small scope, the SQLite is good enough, but for “more serious”, larger scope, better to deploy over Postgres, correct?
-
Whether SQLite or Postgres under the cover, there are no features/functions differences for the Data Table node, correct? At least at this point anyway.
- That’s correct. Though SQLite can handle more than people expect. Biggest reason to use postgres is if you need the DB to be decentralized (like in queue mode being used my multiple workers). With that being said, I always use postgres even on an instance with very light workload
If you’re talking true high scale number of read and writes then postgres is a good idea
- Feature set is exactly the same between them
1個讚
Testing it out. No way to rename a column once created? Please fix.
using variables that are powerful but are somewhat clumsy to instantiate and track since they only work in Code nodes
Just wanted to point out that variables are also available in expressions, under {{ $vars }}
1個讚
You can join tables together in a workflow! Just read the two tables and feed them into a ‘merge’ node — it even has an SQL mode 
4個讚
It is possible access data tables on a custom node ?
1個讚
Hi there! I’d like to ask a question: After Data Tables are officially launched, will the self-hosted Community edition support this feature? Or will Data Tables be a paid feature instead?
As mentioned many times including a few in this thread, the feature is free and available in all versions.
You can get it and self-host it now starting on version 1.113.1 and above
2個讚