Greetings Community! , i want to ask about how blend data works, my original data for sent is (976,933), but when i blend data with another sheet the sent data went over 15 Million.
Is there any explanation why my data went over 10 times??
P.S : When i join 2 table with LEFT JOIN, i only use 1 column called (Promotion) and i didn’t join any other columns.
P.S.S : First Picture from original data source , second picture is blended data.
What are the columns of your second table?
Is it possible that on the 2nd table, you have duplicated values of “Promotion” (e.g 15 rows with the same “promotion A” value). Therefore when joining/blending on “Promotion” column, all the rows of the 1st table got duplicated 15 times?
My columns in the second table called promotion too, but i did create another column called (ID Promotion), so when i join both of the “promotion” on table 1 and “id promotion” on table 2 it shows the right amount of data FOR THE DATA ON TABLE 1, and all the data in table 2 are missing. There should be another data instead of 1 data only.
Need more feedbacks to solve this problem, at least the data from table 1 are correct, but the data from table 2 isn’t showing now..
P.S : I think you were right, because of duplicated values of “Promotion” it got duplicated 15 times.
I think blending is somehow set to return only a limited number of rows.
