User Profile
Andrew__K
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Convert column to rows.
Hi all, trying to convert a column to rows so that the data can then be transposed as its own column. Below is an example set of the data, basically, I want the date/time column to be added as their own rows. Cook Value 1 92.37897 9/01/2023 11:00 AM Cook Value 2 65.54156 9/01/2023 11:58 AM Cooling Value (52°C) 52.38693 9/01/2023 12:21 PM Cooling Value (12°C) 11.96154 9/01/2023 3:00 PM Max Temp / End Of Cook 93.80781 9/01/2023 11:02 AM Cooling Value (5°C) 4.99944 9/01/2023 4:40 PM Below is an example of what I am trying to acheive. Cook Value 1 92.37897 Cook Value 2 65.54156 Cooling Value (52°C) 52.38693 Cooling Value (12°C) 11.96154 Max Temp / End Of Cook 93.80781 Cooling Value (5°C) 4.99944 9/01/2023 11:00 AM 9/01/2023 11:58 AM 9/01/2023 12:21 PM 9/01/2023 3:00 PM 9/01/2023 11:02 AM 9/01/2023 4:40 PM Which can then be transposed like below and the columns could then be renamed, re-ordered, etc... Cook Value 1 Cook Value 2 Cooling Value (52°C) Cooling Value (12°C) Max Temp / End Of Cook Cooling Value (5°C) 92.37897 65.54156 52.38693 11.96154 93.80781 4.99944 9/01/2023 11:00 AM 9/01/2023 11:58 AM 9/01/2023 12:21 PM 9/01/2023 3:00 PM 9/01/2023 11:02 AM 9/01/2023 4:40 PM I feel like I'm missing a simple solution, could anyone point me the right direction? TIASolved641Views0likes1CommentRemove duplicate row, as well as row that was duplicated.
Our labelling software generates a transaction report that represents each label generated, I pull data from this report using PowerQuery. Each row is an individual label or transaction. When an error is made during the labelling process and the operator deletes/reverses that label, the transaction report shows it as a normal transaction with a 1 in a Transaction Type (Trx Type) column, followed by another row with the same information, but has a -1 as the transaction type to represent the deleted label. Is there any way I can remove both these rows in my query? I know I can filter -1 Trx Types, but this leaves the original transaction in place. These is also a serial column for each transaction, these match on the -1 and 1 rows, so could potentially be used? Below is an example of the report. Date Product PPN Description Prod Date Serial Trx Type 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70001 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70002 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70003 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70004 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70005 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70006 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70007 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70008 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70009 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70010 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70011 1 4/12/2023 10751 PRODUCT LABEL (*Deleted*) 2/11/2023 70011 -1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70012 1 4/12/2023 10751 PRODUCT LABEL 2/11/2023 70013 1 Any help would be appreciated. Thank youSolved939Views0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.