演示数据(load sample data)
......
add F
(
consolidate_all_sheets:
多表合并到数据库consolidate sheets
pull in data from many sheets) (
背景background
)
copy from Excel(video)
文件名 表格名 f01 date divison amount account indirect_example_1_z.xlsx setup f01 date divison amount account indirect_example_1_z.xlsx setup f01 date divison amount account indirect_example_1_z.xlsx setup date US indirect_example_1_z.xlsx setup divison UK indirect_example_1_z.xlsx setup amount DE indirect_example_1_z.xlsx setup account indirect_example_1_z.xlsx data1 date divison amount account indirect_example_1_z.xlsx data1 7/20/2024 DE 212.34991441739 Sales indirect_example_1_z.xlsx data1 4/27/2020 DE 376.57182416611 Sales indirect_example_1_z.xlsx data1 1/13/2024 DE 140.50913421631 Sales indirect_example_1_z.xlsx data1 9/14/2021 UK 430.72176922362 Sales indirect_example_1_z.xlsx data1 7/25/2021 UK 342.69573773623 Sales indirect_example_1_z.xlsx data1 10/23/2020 UK 272.46625258421 Sales indirect_example_1_z.xlsx data1 5/19/2024 UK 180.70612093631 Sales indirect_example_1_z.xlsx data1 4/25/2024 UK 499.02795512365 Sales indirect_example_1_z.xlsx data1 12/13/2020 UK 296.53229698937 Sales indirect_example_1_z.xlsx data1 6/3/2022 US 161.61877180462 Sales indirect_example_1_z.xlsx data2 date divison amount account indirect_example_1_z.xlsx data2 11/18/2023 US 159.42512246851 Assets indirect_example_1_z.xlsx data2 2/12/2022 DE 135.96675254977 Assets indirect_example_1_z.xlsx data2 11/11/2021 UK 428.5573895149 Assets indirect_example_1_z.xlsx data2 4/18/2023 UK 261.45936606464 Assets indirect_example_1_z.xlsx data2 12/14/2022 US 156.27362151396 Assets indirect_example_1_z.xlsx data2 9/11/2023 DE 133.15519010754 Assets indirect_example_1_z.xlsx data2 5/16/2022 US 431.45638680652 Assets indirect_example_1_z.xlsx data2 4/4/2022 UK 267.82234383073 Assets indirect_example_1_z.xlsx data2 11/16/2022 DE 345.22447236943 Assets indirect_example_1_z.xlsx data2 12/14/2021 DE 139.81482060704 Assets indirect_example_1_z.xlsx data3 date divison amount account indirect_example_1_z.xlsx data3 4/24/2023 UK 228.78277342926 OpEx indirect_example_1_z.xlsx data3 7/17/2024 US 321.65771522053 OpEx indirect_example_1_z.xlsx data3 11/15/2020 US 110.70532532648 OpEx indirect_example_1_z.xlsx data3 2/18/2023 UK 483.92731329177 OpEx indirect_example_1_z.xlsx data3 2/27/2023 DE 248.75539193054 OpEx indirect_example_1_z.xlsx data3 12/13/2023 UK 219.60093590123 OpEx indirect_example_1_z.xlsx data3 2/12/2020 UK 127.16739638698 OpEx indirect_example_1_z.xlsx data3 7/5/2020 DE 302.66743224629 OpEx indirect_example_1_z.xlsx data3 10/10/2022 UK 207.14003999794 OpEx indirect_example_1_z.xlsx data3 8/12/2022 US 293.88230594255 OpEx