❔ excel data processing
I have 4 excel files here, 100239421003 file contains a Statis page, other (_1, _2, _3, _4) files have a Detail page (contains 100239421003 file).
Statis page and Detail page contain the Steps column, Steps is similar to the foreign key field in the database, to find the corresponding data in the Detail page according to the Steps in the Statis page, and get the maximum value of other columns and other information, Similar to (select max(Voltage(V)) from Detail where Steps='4') or (select * from Detail where Steps in(select Steps from Statis) where State='Rest')), now my practice is to first analyze the columns, and then create Statis table and Detail table, Statis table stores the Statis_33_12 page data in 100239421003, The Detail table stores the data of page 'Detail' whose Name contains 100239421003, *_1, *_2, and *_3. Is there another way to do it faster? For example, you can directly manipulate excel, but excel is very slow to retrieve Detail
Statis page and Detail page contain the Steps column, Steps is similar to the foreign key field in the database, to find the corresponding data in the Detail page according to the Steps in the Statis page, and get the maximum value of other columns and other information, Similar to (select max(Voltage(V)) from Detail where Steps='4') or (select * from Detail where Steps in(select Steps from Statis) where State='Rest')), now my practice is to first analyze the columns, and then create Statis table and Detail table, Statis table stores the Statis_33_12 page data in 100239421003, The Detail table stores the data of page 'Detail' whose Name contains 100239421003, *_1, *_2, and *_3. Is there another way to do it faster? For example, you can directly manipulate excel, but excel is very slow to retrieve Detail
