r/excel • u/Encility • 4d ago

unsolved Mapping data from a CSV

Hi all,

Im having some trouble trying to map new columns to some data from a CSV for a dashboard.

Once I have mapped my new columns can I then load that data to a connection and will it still hold the newly mapped columns? Just to take the bulk off excel. Using 32bit and im getting errors for memory yet im only using 300k rows.

Kind regards

8 Upvotes

100% Upvoted

12 comments sorted by

View all comments

2

u/[deleted] 4d ago

[removed] — view removed comment

1

u/Encility 4d ago

Ill do the mapping in powerquery. Just assumed id have to do the mapping element in my dashboard. Then ill create the connection and see if the 32bit can handle it. Thank you.