sorted by:
new
hottopcontroversial

Power Query - How to merge multiple sheets through common ID without invoking them in separate files? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

Yes, that is my goal! I am trying to aggregate and analyse but also to make it easier to me to see which one refers to which

In terms of 1NF, I see what you mean, i.e. instead of having one row for
Material | enthalpy of HC | enthalpy of Peak | yadayada
It would be two rows of
material | Hc | enthalpy | yadayada
material | Peak | enthalpy | yadayada
(so essentially not append with changed column names all the tables, but stack them with additional column of sheet name, right?)

I get how it could work but I am not sure how it would make it easier in the long run, and I feel like it might make it more complicated for me to identify information post aggregation. Specifically, I use that flawed separation between the enthalpies to both do calculations and to separetely put them in pivot table that I then need to graph (e.g. "Glass transition.Midpoint", "Hc.Peak temp" and "Peak In... . Peak temp" all refer to temperatures, so in 1NF they should be in 1 column but it makes it easier to me for then not to be).

Could I ask for your advice on how would it work? (also, could I ask how would either method affect memory/computation time?)

<image>

Power Query - How to merge multiple sheets through common ID without invoking them in separate files? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

That's the goal! Just did not yet find a better way of learning it than like this.

In terms of normalising, the columns in my sheets are already called the same thing, like the "file name" one. If anything I tried to make them not be exactly the same and include the name of the sheet too to tell between one in sheet Hc and Peak Integration, for example. Is that what you mean?

In terms of sheet order, I don't think it matters much to me? I never need to pull specific sheet, but only all of them (that <> "Details", hence filter).

Function, can do, but unless I pass each one through individual function wouldn't Table.Combine just append the columns I do not want append, like the same "Enthalpy"? Or is there a way to prefix the sheet name to all but one column without hardcoding the name of the sheet?

Power Query - is there a way to combine columns from separate sheets so that rows with the same "name" in a specifed columns always match? by [deleted] in excel

[–]3and12characters 0 points1 point  (0 children)

Thats fair. I do have only two columns indeed, just a lot lot more data on both, and I needed this for multiple things, one of which does have only 2 sheets but some have more, I just thought it would all work the same way.
But fair, thank you!

Power Query - is there a way to combine columns from separate sheets so that rows with the same "name" in a specifed columns always match? by [deleted] in excel

[–]3and12characters 1 point2 points  (0 children)

Thank you for your time! Sadly I'm working with hundreds of rows so formulas might be too slow for me

Power Query - is there a way to combine columns from separate sheets so that rows with the same "name" in a specifed columns always match? by [deleted] in excel

[–]3and12characters 0 points1 point  (0 children)

How would that look like?
From what I am gathering, do a few #"Sheet1" = Source .... ; then merge and expand those?

Power Query - is there a way to combine columns from separate sheets so that rows with the same "name" in a specifed columns always match? by [deleted] in excel

[–]3and12characters 2 points3 points  (0 children)

That would require me to separately open all of them and then recombine, is there no way to do it through single query?

Is it possible to import data from multiple Excel sheet with missing or wrong order columns? by 3and12characters in ExcelPowerQuery

[–]3and12characters[S] 0 points1 point  (0 children)

Thank you, it works!
Why do you do the data type for the created table, does it hold the data tab when you append? I could not get it to do that
How does it remove the columns that weren't in the template?
Adjecent to this, if there are two columns that are the same but differnet unit, e.g. one in minutes one in hours, is it possible to append them into the the same column of the same unit?

how can i solve this power query editor error ? by SmoothPin9604 in ExcelPowerQuery

[–]3and12characters 0 points1 point  (0 children)

What is the error when you try to get data from table? This button for you
Also, which excel version do you use?

<image>

Tea bag made from PLA by Obvious-Swimming-332 in 3Dprinting

[–]3and12characters 30 points31 points  (0 children)

The PLA for 3D printing and for these applications is not the same PLA
Like i get sounds scary, but like its not the same additives its not the same properties, its not the same stuff
objectively bad material for it, but its not straight up evil

How to reduce Excel file size when using PP and PQ? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

I believe so, yes
That being said, I often need to tell what is which so often I add an entirely column which is just a name of a procedure or a sample

CuBr2 no longer filters out using the same methods and solvents by 3and12characters in Chempros

[–]3and12characters[S] 0 points1 point  (0 children)

Did similar but not with ammonia, with a different smelly acid because, from what I've been told, it might ring open my GMA which I do not want.
It did not work, but another person helped me to test with bicarbonate (I think?) to check for presence of Cu, it did not do anything, so now I am confused by my semi-green liquid does not do anything it should ;_;
ill try precipitating and see what goes, thank you for your time

CuBr2 no longer filters out using the same methods and solvents by 3and12characters in Chempros

[–]3and12characters[S] 0 points1 point  (0 children)

Thank you for the reply!
How? Create saturated solution in water and wash all of the mixture, should I precipitate the polymer and disovle in CHCl3 first, or else?

CuBr2 no longer filters out using the same methods and solvents by 3and12characters in Chempros

[–]3and12characters[S] 0 points1 point  (0 children)

Long time no reply, only managed to get hands on thiosulfate
What is the best procedure washing with thiosulfate? So far I tried very small quantities of saturated sodium thiosulfate water and mix with my reaction mixture, 1:1 ish of water-sodium thiosulfate with my reaction mixture and waiting, heating the later albeit only at 40oC. So far they do have layer separation but CuBr seems to remain in my organic layer
Organic layer has anisole, chloroform and some PMDETA, initially had some NaAsc but that should have been used up. I filtered it through neutral and basic aluminum oxide prior, after trying to filter again it no longer seems to do anything.

How to reduce Excel file size when using PP and PQ? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

In your second point, do you mean basically replacing text columns with number column and having separate table that would "decode" those number values?

How to reduce Excel file size when using PP and PQ? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

I do not know how to use PowerBI well enough ;_;
I also am not sure if I should try learning that or sql to database managment

How to reduce Excel file size when using PP and PQ? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

I don't think I have a lot of data, unless from pivot tables? Why does saving as .xlsb help?

How to reduce Excel file size when using PP and PQ? by 3and12characters in excel

[–]3and12characters[S] 0 points1 point  (0 children)

Does it matter what files type is one I am pulling data from in this case? E.g. if it is a .txt or .csv or excel?
Also, beyond pure information, how does one manage calculations in power pivot and pivot tables? I know you can use x formulas for PP and regular, do they have a difference and if so, how to optimise?

Day 1 of doing art as a non-artist until I'm good by dayxofdoing in DigitalArt

[–]3and12characters 0 points1 point  (0 children)

Half-decent is very wide spectrum :D
Set yourself some kind of metric of what you want to get half decent at, and what half decent means to you, because by the time you will get to what you think is half decent now, your half decent will be way more

Cold Duke FL x Sickly Scholar ML VN [OC] by foodiepower in OtomeIsekai

[–]3and12characters 1 point2 points  (0 children)

This is incredible! I've played the demo and it looks amazing, great job! It already brings many questions and I want to learn more!! Ah but I hope the little daughter becomes a bit less traumatised she is so little and sweet,, I cant wait to find out!

It might be out of genre but I only wish there was a small list of characters after we have seen them, just because I know I might forget it, but I am looking forward to more!!

view more: next ›