[数据处理]
大量字段拆分成三个表 如何保持数据的同步性
-
Adaa
- 2022-10-12 09:31:11
- 发布在 论坛
3045
12
自由表列数有限制 如今200+字段拆分成三张表的话 如何让后面两张表跟第一张表一样数据同步呢 就是排的顺序也按第一张表顺序一样这种 |
免责声明:本文不代表本站立场,且不构成任何建议,请谨慎对待。
版权声明:作者保留权利,不代表本站立场。
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 09:31:12
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAOUAAABfCAYAAAAXmAAFAAAJxUlEQVR4nO3dTUwbVwIH8D8Lm4IgUVeNicJuEoeaNB0ipd3cckkqbDgicbEd9WajcLG5RiL2YQwSp0iLLyDbtwjDBclHYqMSaeVb1EbC04rMZk2ySYSnq+1ugvLROOxhDP7AH4CN/YD/7+aZ8Ztnaf7vvXlvYJrevf+wCSISxh8aXQEiysdQEgmGoSQSDENJJBiGkkgwDCWRYBhKIsEwlESCYSiJBMNQEgmGoSQSDEMpEi0Kj20MMa1guxKA3RaA0pBKUb3VMJQpxO5aYQ8m8j4Hc68kLQrPbi8uJQB7sQv0gGnRMXiiqRJ7EwjWvU4pxGZjgPk6pHqelhqmpWYlaY/xUDXDM95bm+JeJAHzLZgN+/x+dAxTGIXP0ln0cymGb24CLheCf56HsyAFSlDGktmLcNE6JRC0yVjadQ1NcPgnKv8+JYKQCkCVYY/tsww6VGoWSiUSxAXv/P5acy0KjysIdceOYhfiFjM8c8PFz6cE4A4Bfd6tDSloMAIhF+xrXoSdZRoOgwVuxzLccgDXc8rXomPwxczwzJX6bi+cc/Nwli65NCUAu5z9oarLihBMcPhHgVl9e583v5FQglb4kjdxlYE8cmoTSiUAH7wIS/rF6354E1PjV/dYSJmQFdKi8LiSJetil2MFF3EnJMswfJbrCNpk2JNOTI1bYCjyvSwVPlthi5C7bQ/1rUQaRnhuOPO7lnFjq/dTArDDiSk/MOUKQMmcTwlaMw1EwW+gI6EGoUwgKCPTgyQQCQEOvwUGlLovO0BFA5mrF845L2CT4bYld4bKVBjWFGJ3XUjeKiivXKNQBe2nZagAbmydezYJx+gwDAbA5w3AbrNmjqxhg0DCqT6U2kusIYYlW3aYpd/jaEiqJhhzm3ItWWSIWkgPQqjYgebSQ08tOgZ3SEWf2YylgqFnln7fB68fjlkXfDbkX9xqEG5bcGfhsrXIvaJ5x7n3Zfs3pfD4oV5GyGXFQ4cfvvGJ7Dle5DQCJiN7yCOs+lAaLPDNWbYnUvJ7KBVJDci/gpJ4qQFShavK5PDnTcpo0TG410odnUAkpGZ6yBSMSRfiyjCkwlQqcSzBDI/UCWncD9wtOG6fPaXBMoGwZed+e07glaAV4Qv+0hNN2mPomdQnb7oiY4hpE+iKWOGLAXrvOAEpUye3LVi2kaLDqyZLInpgbuVfcNpLrAFYkrPLInprnwlqTWUmWSQA6IT5lhlL8UTBMfrSgskxmAlKJ8zjpYa59adEglBNJpgynyXnKPA3K3xJJ6bm5hHeDrhe7/CcH46kzPXLI6gm95SRkIrcmdI+7zwGXyxDNTnhubEMnzwGo38Uma4AS/EEnNIBtvDSIByzLgSVnNApEYRUMzzjZZZE9jl83UFLQt3LEFOLIhwzw+M3IuxazmzUw1f6LJX202FVg1AWWwpIITarwnRjFJLFAs+aFeFIBFBNcHhv4uHsS2joLXvRqiEX7KGCjbu+AjthHnXCsz1jmUBQjsHk8JefHKnRRI8+IjDutrKAlgQcg5DwuGBHhbXPHfWlo6B2Dw8gO4wNX48jpJrgGNV7Jck5D3d0DG7TTbilLiRVGRHFUnboWHhPuWcGiz5jeTeAPsSwZHJiqlx50jDC43soe67UTn3CxnRjtGJY9LVGJ6bGh+GTAJQY1hedTVYCsM/usr50qNRsndKe6YnCTiB2NwaYvdknTbQopkIq+rwTMAAYdJjgno1isGgrX7thmRKPASr0yZ2Sa3plZnu3FB2+6nY0Hkokr0GqyNjFno7yVB9KJQB7/Lq++A299Q/lPW6XQNAVhGr26r0BAIPlFvpCMqaiV6vrDcvVSY7pw7s5CwxIIGizwld0trJcI1Bi+FqKFoUn0zhVfvQtgXgMMDkYScpXfSilYYS3L9gE4jETHP6ctT8lrg8d88LQC6ffCY8rAsWyl6d4ch7FM3t3fC+7XmiCwz+fE4zMfa8SgN0m4yAW37fOXWrYLQ06AVfBfXKlIXXGUqme2rSvh/pIcE1H4bUF+mNn2MO6XXYCpfTTP8Bue8rsY29VBr3wMbvthx1K3VMaOdFzBB2JUBIdJfwjZyLBMJREgmEoiQTDUBIJhqEkEgxDSSQYhpJIMAwlkWAYSiLBMJREgmEoiQTDUBIJhqEkEgxDSSQYhpJIMAwlkWCq/ncgH3//gFevXuH169f49OlTLepEVJWOjg68efOmrudsb29Ha2sbznZ1VV1W1f95IPnPp9jc3ERPTw+am5urrhBRtR49eoRr167V9ZzpdBrPnz8H0FR1MKsevr59+xbd3d0MJB1rzc3NOHfuHN69e1t1WVWHMp1O48SJE1VXhOiwa25uxsbGRtXlcKKHSDAMJZFgGEoiwTCURIJhKIkEw1ASCeaQhHIF00NDmF5pdD2IDl5NXxq7Oyks3hnBzGq5Y/ohL4zgSr2qRCSQBoSyEwOTCxjIfFqZHsL9i9OYHCh4JdzKNIbuX8T05AAO4A2WRMJq7PA1tYj7D/rxfWEgiY6xBvSUWakff8AqVuEdepCzlUNXOt4aGMoVLMwAt6cXsN1RZoas7DepHrQnP+HZRivOmC7jLx3Fj3nzr1+grr9D+/lv0FOnt/M2bPiaWryPB/3fI3fkuvL3B7j03bcMJdXFyVNtaElvYH11BcnfPhbs/YjXawpW1zeQbmnDqZP1q1djQplaxL0ZI+SRK3nb7j+4hO++ZSSpPlrPfAXp/Cm0bL7Hv/+RwBPt98yej/j16c948utbbLacwnnpK5xprV+9GrMkcm8GRnkBnYt3MJS7NtIvY5KZpDr6o6EHvU1P8fOz/+B/zxL45f2XOP3uKdb++xFNJ/6EC19343SdU1L/njL1I34wyhi5AnQOTGJhYQHTty8B6M/vOYnqpOV0N77u/gKfNaWxsb6qB/KzL9DdgEACjQhl5wAmc8O3Mo2RmVX0y5xxpcZp+dyIyz2n0dYENLWdRs9lIz5v0DRoY5dEFu9kArmAHZ3klREsTDakWnRMtZy8AOmvFxpdjUaFMvuoXdFAFnUJF3m/ScdAQ0KZWryHmdUKDwmkFnFnZAbb00CXbmOaoaRjoCGh7ByYxMJAxYMwWfEgoqPnkPzpFtHxwVASCYahJBIMQ0kkGIaSSDAMJZFgGEoiwTCURDWSTqfR3t5edTlVh7K9vR3r6+tIp9NVV4bosNp6P2VrW1vVZVX90tgmbOLZs2d8kzMJoyFvcu7oQGtrK86eFeBNzkRUW7ynJBIMQ0kkGIaSSDAMJZFgGEoiwTCURIJhKIkEw1ASCYahJBIMQ0kkGIaSSDAMJZFgGEoiwRxwKD9AU5bxWCvYvJFEPP4Evx3syYkOpf8D6ljByGnYtJYAAAAASUVORK5CYII=)
这里修改成图片上的试试呢 |
|
|
|
|
yhdata_yzm
显示全部楼层
发表于 2022-10-12 09:46:12
|
|
|
|
Adaa
显示全部楼层
发表于 2022-10-12 09:58:20
但第一张表每一个字段都以前一个字段为父单元格 这种情况下 后面两张表也只用取第一张表其中一个字段即可吗 |
|
|
|
|
yhdata_yzm
显示全部楼层
发表于 2022-10-12 14:04:30
|
|
|
|
Adaa
显示全部楼层
发表于 2022-10-12 14:29:40
好的 谢谢 不过还有一个问题 就是第一列我用序号的字段 放在表里 理应是1234这种排序 但是有很多重复值 请问这种怎么调整哇 |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 14:47:03
|
|
|
|
Adaa
显示全部楼层
发表于 2022-10-12 14:50:34
这张是数据集中显示的
在报告里就成了这样
|
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 14:59:01
|
|
|
|
Adaa
显示全部楼层
发表于 2022-10-12 15:08:58
|
|
|
|