Forum Discussion
Merge Tables with Duplicate Column Names and Add Values
Without further help to implement the above is unfortunately no use to me - please do not think I am giving negative feedback towards the solution - I just do not understand it and would need further help here. Moving forward then I would love another solution or suggestion on how to tackle my problem. The method I have been considering is to setup the intitial CSV with 4 or 5 containers for every single variable. Then my power query instead of just merging tables would look for those 4 or 5 containers, sum the values, and create a new container called (giving an example of one variable here) "Job Tech Sum". Then it produces the table based on those Sum columns instead of any of the base one out putted by the campaign system. Let me give an example of what I mean here.
CSVs would look something like this
| A | B | C | D | E | F | G | H | I | J | |
| 1 | Source.name | job tech | job tech_1 | job tech_2 | job tech_3 | job tech_4 | job tech_5 | cul tech | cul tech_1 | cul tech_2 |
| 2 | Dummy1.csv | 1 | 1 | |||||||
| 3 | Dummy2.csv | 1 | 1 | 1 | 1 | 1 | 1 |
So when I merged previously, only the first column name would create the table because there are no values in the other columns. By doing the above, I will need to limit the number of times a variable can appear in the email to a max of 5, and instead of just merging the tables, I now want to setup the powery to first look for columns B to G, sum the values, and create a new column called "Job Tech Sum" which has the total value for that month (or row).
This level of solution is something I'm able to understand but I am not sure how to do the checking, summing, or creation of a new column in power query.
For some insight, I am a HR guy and this is a project aimed at figuring out what type of informaiton will help people the most. I am not getting paid for this - it's purely to try to help people as a side project for the company I work for. I've learned everything I know on this in the last month, and I'm trying my best. If there is somebody out there with a little patience to help an averagely intelligent HR guy finish a tech project - well there may be a place in heaven for you.