Forum Discussion
Tables structure issue
Hello Eyelyn and thanks for getting back to me.
Yes, I did try to merge the queries but without getting the result I wanted. My idea of knowing "from which tables data were coming from" was becasue the table name was already allowing me to filter the type of data.
However, I think I solved my problem using the List.Zip function. Solution was not "mine" but I took if from THIS video. With this trick, I don't even have to split the original source data into two tables (market & MyShare).
It perfectly does what I needed to with little if no effort for data-cleaning...
You should unpivot the category columns on both tables and then append them together to have the best table structure for analysis/visualization. Once appended, you can disable load on both source tables so that you only load the combined table.
Pat