Excel Forum

Convert a huge text file of Sales Using Power Query as Per Sample Attached

Rashid Khan

Member

Members

Forum Posts: 7

Member Since:
July 1, 2021

Offline

October 27, 2022 - 7:05 pm

Hi Everyone,

I am enclosing herewith a text file which I would like to convert as a Final Output as per the sample attached using Power Query.

I would really appreciate for any help in this matter

Thanks in advance.

Rashid

See Answer

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 440

Member Since:
January 31, 2022

Offline

October 27, 2022 - 8:30 pm

Hi Rashid,

Please try attaching the file(s) again. Don't forget to press "Start upload" before you submit your reply.

Riny

Rashid Khan

Member

Members

Forum Posts: 7

Member Since:
July 1, 2021

Offline

October 27, 2022 - 10:52 pm

Dear Riny

I did.

Please see it if available now.

Thanks.

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 440

Member Since:
January 31, 2022

Offline

October 27, 2022 - 11:44 pm

Thanks, but I don't really see how the txt file relates to the desired output.

Rashid Khan

Member

Members

Forum Posts: 7

Member Since:
July 1, 2021

Offline

October 28, 2022 - 3:59 am

Dear Riny,

Extremely sorry.

I attached a wrong sample txt file. Please find herewith the correct file,

The output file is a sample of the output required where you may find some companies missing but you will get the overall idea of the output required.

As this is done by manual copy and pasting so chances are there some records might be missing.

Thanks for your time.

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 440

Member Since:
January 31, 2022

Offline

October 28, 2022 - 5:49 pm

The attached PQ solution isn't going to win a prize for being the most beautiful piece of art, but it seems to work. The last two columns with amounts agree to the Output file you sent earlier. The first, however, does not. Several larger amounts are missing the first digit(s).

Please check it carefully.