Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Streamline log table
Good morning I have a data record in a SQL database, which is saved as follows: Date Type Value 23/11/2022 14:26 Registration 3984XXX 23/11/2022 14:26 Loading area A 23/11/...
v-jianboli-msft
3 years agoCommunity Support
Hi Syndicate_Admin ,
Do they have some kind of logic? Or are they random? If they are random, please consider adjusting your data, otherwise it will be almost impossible to convert them into the results you want.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin
3 years agoAdministrator
Each data is with its corresponding Type. Is there a way to group the data as a subset that is then transformed into a row to get the final result?
Let me explain: each transport can be characterized by these 4 parameters. Identify them as load 1, load 2, load 3, and then transform the data.
It's possible?