Hello Everyone,
I need one suggestion on implementing one functionality. I am reading data from multiple excel file using macros and loading data in table. The header of the of the the of log files are changing but need to concatenate data at row level and store in table. Getting issue when trying to map these excel column to DB table as it is changing for each file.
E.g Sample 1 excel input file
| Column 1 | Column 2 | Column 3 | Column 4 |
| a | b | c | d |
| e | f | g | h |
Sample 2 excel input file
| Column 5 | Column 6 | Column 7 | Column 8 |
| i | j | k | l |
Structure of database table to load data from above two sample file.
| Log_Filename | Value 1 | Value 2 |
| Sample 1 | a|b|c|d|e |
| Sample 1 | e|f|g|h | |
| Sample 3 | i|j|k | |
