Excel to Table data flow with multiple sheets with same structure but different column names
i have an excel with multiple sheets, where in sheets the number of columns/structure remains the same but column name varies.
For e.g. in Sheet1 structure is as follows:
Group Category Score Strongly Disagree Disagree
Filter A All 78 39 135
26 - 30 Age Range 80 10 48
31 - 40 Age Range 77 20 49
in Sheet2 structure is as follows:
Group Category Score Very Weak Weak
Filter A All 75 43 131
26 - 30 Age Range 76 16 38
31 - 40 Age Range 72 15 57
In Sheet 3 structure is as follows:
Group Category Score Almost Never Seldom
Filter A All 79 49 101
26 - 30 Age Range 79 18 33
31 - 40 Age Range 79 16 54
My requirement is that my sql table should have structure as
Group Category Score Strongly Disagree Disagree
but with values from Sheet1,2 and 3. It should consider 'Strongly Disagree', 'Very Weak' and 'Almost Never' as one single column with heading of 'Strongly Disagree'.
Currently my foreachloop is skipping the Sheet2 and 3 as it is only picking up the Sheet1 structure and storing the same info in the sql table.
How to achieve the Sheet2 and 3 data also in the sql table?
