Trusted Data|VBA & Macros|Excel Forum|My Online Training Hub

Hi Catalin,

You are amazing! 

Wow! This is awesome and it works like a charm. Thank you so much!!!

Yes it is working correctly without any issue. I just have below question, please can you check.

Some sources show different Country for same company so I extract data from DB using SQL by below structure

The result using Power Query as below.

So I changed the IDs to make each row has it is own ID and I got good result as I want the Trusted Data per row then I will get  DISTINCT for "Company & Country" then I will take Country which have the big count of sources as below.  Do you think is there any issue will happen if I do this?

How kind you are to help me.

Thanks;

Marsil

Hi Catalin,

Great so I will make the ID's unique.

Last question please.

I will use this file for other types of data like I will compare Found Year, Phone, ....etc.

So I face as issue to determine the count of sources which I past it in "M column" as I use this function =COUNTIFS(R3:AD3,"*",R3:AD3,"<> ")

as it is count the characters not numbers, so can you help me to find other function work with characters and numbers please.

Or If there option on Power Query to count the sources and fill M Column ?

Thanks for helping me accomplish my goal.

Thanks;

Marsil

That's a huge help - thanks!

I added above formula and it is running without any issue.

I did other thing and I want to know your comment please.

I removed Changed Type step due sometimes I will want to remove column from sources or change it's names as the sources not fixed as may be I got from other sources like Amazon, yahoo finance, ...etc.

Also may be I will add more columns for sources.

I tested the result and it's okay, but I want your help to review this update in attached file to make sure there is no issue on any step in code as it is first time to make edit in Power Query.

Thanks is not enough, but really don't know what else say to you. Anyway have to say thanks again.

Thanks;

Marsil

I think above issue won't happen as I removed Changed Type step to make the file don't depend on columns names.

Example I changed the columns names as below and it is working without any issue.

Are u intent this or other thing? as I will depend on this file on urgent project.

Thanks;

Marsil

Ofcourse, when I work on this, I will work per feature foe example after I finish HQ and get the final result, I will start with another features like Phone.

I won't work in different values on the same time.

below table will cause issue.

But below one is correct

Thanks again. Couldn't have done it without you.

Tahnsk;

Marsil

First,  I wanted to send my thanks for all your assistance.

Here all details about what I will do, please check.

I build profile for many companies contain many features like Company Headquarter, Phone, Address, Founded Year, Stock Exchange Name, Email, EmployeesCount, Industry, FiscalYear, Logo and MarketCap

And I do this via extract these data from many sources like The Wall street, Blomberg, …etc. and will verify the accuracy by comparing the data which I extracted it.

So the file which you sent me will help on comparison to get the Trusted Data, I think all of features can use the same Trusted Data process.

But I think there are two feature won’t be done with Trusted Data process, please check below.

• As not all sources write the address with same format.

Ex: CompanyName: News Corp

The Wall street_Address: 1211 Avenue of the Americas New York New York 10036 United States

Alacrastore_Addres: 1211 Avenue of the Americas New York, NY 10036 United States

Marketscreener_Address: 1211 Avenue of the Americas New York, NY 10036

Owler_Address: 1211 Avenue of the Americas New York, New York10036

• Logo, I got the image URLs and I downloaded it.

Please can you help how I can do this as I try to get any idea.

Thank you very much; your support is greatly appreciated.

Thanks;

Marsil