Forum Discussion
Modify table tricks needed
Alright, give this a try:
I begin with this table:
Create a duplicate of this table, now we have Table 1 & Table 2.
In Table 1, filter reason for call on "Loading":
In Table 1, highlight [Trip number] and [Unit Number] then press "Group By". Use the same setting as the picture below:
Now we move onto Table 2. Filter the table on discharging then do anoth "Group By" with these settings:
Finally we want to merge the two tables. Press "Merge as New" then use the following settings (Ctrl click to highlight more columns):
Finally expand the "End" column:
Should give you the following result, which i hope is correct:
Br,
JHappy to hear! I can actually help you out with that 😉
Br,
J
The reason that the two columns are not present is that they are calculated columns, they depend on the datamodel as it is when it's loaded and they cant actually exist before the load!
What we want to do instead is write a table statement, i'd say we want to do something like this:
New Table = SUMMARIZE( 'Table (2)' ; [Trip Number] ; "Start" ; MIN([Start]) ; "End" ; MAX([End]))
Let me know how it goes!
Br,
J
Hi, Sorry I dont quite understand what you meant, i just want these calculated columns appear in Query Editor... What can I do to achieve that?
But I did make the table you recommended... However, it, also, does not show up in Query Editor...
What should I do if I want to be able to do some editing in Query Editor?