populate Column with names from 3 different tabels if....

[nahaku]

TeamPerformanceSmallmanV1.xlsx
	A	B	C	D	E	F	G	H	I
1	Team Members	Team	Product	Sale Date	Region	Login Hours	Total Talk Time	Total Hold Time	Sales
2		Team A	Product 1	01/06/2014	Alabama	7.0	6.0	0.5	22
3		Team A	Product 2	01/06/2014	California	7.5	6.5	0.7	19
4		Team A	Product 2	02/06/2014	Colorado	8.0	7.0	0.5	45
5		Team B	Product 2	03/06/2014	Florida	8.0	6.0	1.2	50
6		Team C	Product 2	04/06/2014	Florida	4.0	3.0	0.5	55
7		Team D	Product 2	05/06/2014	Alabama	8.0	6.0	1.4	60
8		Team E	Product 1	01/06/2014	California	9.0	8.2	0.7	18
9		Team F	Product 1	02/06/2014	Connecticut	7.6	6.6	0.7	18
10		Team G	Product 1	03/06/2014	Hawaii	4.0	3.0	0.5	18
11		Team H	Product 1	01/06/2014	California	7.6	6.6	0.7	18
12		Team I	Product 1	01/06/2014	California	7.6	6.6	0.7	18
13		Team J	Product 2	05/06/2014	Alabama	3.0	2.0	0.5	70
14		Team A	Product 2	05/06/2014	Alabama	8.0	6.0	1.4	80
15		Team B	Product 2	05/06/2014	Alabama	8.0	6.0	1.4	80
16		Team C	Product 1	02/06/2014	Connecticut	3.0	2.0	0.7	24
TeamPerf

I have this table. where i want to somehow get the Names from 3 other tables what contains different type of data, some Names are repeating in those tables some are only in one of those 3 tables. I would like to import those names in Column B, so I can then use those names to populate rest of the columns in this tab based on the logins in column B. I tried to do it by Power Query but it seems to does not want to make relationship between my Querries "Connection only" tables what are filtred to my needs, but I did not put them in Table format to excel.

 

[sandy666]

one column with only Logins I want to extract and merge this would it work?

re-read post#5 first part
Power Query has no limit with number of rows

check this as example s666-PQ-test15042020.xlsx

 

[nahaku]

:P yea. I did not get a meaning of the sentence. English is my 2nd language.
I made it work, I am now using just for test data from 4 months, so i got 500 000 rows, later if we do it weekly or monthly it will be much less. Maybe even for day it could work.
but I have different issue now even though the names are good. it is mixed up, i got basically 3 different tables in 1. but rows are mixed up with dates.
see the picture to show what I mean. Do you think is it possible to do some steps to get dates in same row within the power editor? It would be much easier if i can Merge them by name and date in same time.
Or should I just leave it as it is and use this format only for daily reports, where I will get data for each day separately.

https://imgur.com/QqMBtSu

 

[sandy666]

I am not interested in pictures which are useless, sorry
I gave you example file so you can see the way with "login" column only added to the tables

 

[nahaku]

I am not interested in pictures which are useless, sorry
I gave you example file so you can see the way with "login" column only added to the tables

:P the trick was to hold CTRL :D I hate when so obvious things are not clearly visible, I found it on another blog post. When I am selecting in Merge, what I want to merge by, I can hold CTRL to select multiple columns and it works fine. Thank you for keeping up with my silliness. Have a great day.

 

[sandy666]

You are welcome