Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
iulian93
 | Femeie
25 ani
Ilfov
cauta Barbat
27 - 68 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
Instead of going through Pivot/Unpivot Columns, I just need 3 a few values to be loaded onto the even rows instead of the odd ones.
I have the value on row 1 (index 0) and the quantity on row 2 (index 1).
I just want the quantity on the same row as the value.
1. First, add an Index column (Add Column - Index Column)
2. Then add a Custom Column, and use a formula similar to:
| if Number.Mod([Index], 2) = 0 then #"Added Index" [intrari] { [Index] + 1} else null) |
Number.Mod([Index], 2) = 0 checks whether the value in index column is divisible by 2 (even number)
#"Added Index" is the previous step - since you also probably just added the Index column, it should be the same.
[intrari] is the column that contains, on odd rows, the value I want moved to even rows
{ [Index] + 1} is the way you refer to the Next Row
Source:
https://goodly.co.in/refer-previous-row ... wer-query/
|
|
| |
|
