Hi Hello. I have this table record below.
ID | Digital | Industrial | Intralogistics |
6129740673d | Big Data | Machinery | |
6129740673d | Cloud Computing | ||
6129740673d | Cyber Security | ||
63018356c37 | 3D Modelling | Logistic IT | |
63018356c37 | Space Solution | ||
69562a28468 | Product Development |
I would like to fill the empty rows with the value above while grouping by the ID. So for example, 'Machinery' to exist on all 3 rows of 'Industrial' where 'Digital' exists for ID 6129740673d . Similarly, for 'Industrial' column for ID 63018356c37.
Hence:
ID | Digital | Industrial | Intralogistics |
6129740673d | Big Data | Machinery | |
6129740673d | Cloud Computing | Machinery | |
6129740673d | Cyber Security | Machinery | |
63018356c37 | 3D Modelling | Logistic IT | |
63018356c37 | 3D Modelling | Space Solution | |
69562a28468 | Product Development |
I tried using Multi-Row Formula with reference to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/replace-null-value-with-last-previous-... . It works but it only affects one column each time.
' if IsEmpty ([Digital]) then [Row - 1: Digital] else [Digital] endif '
Considering that I have more than 8 columns, I'm hoping there is a more feasible approach.
Solved! Go to Solution.
Hi @reignM ,
In this case, to proceed with some fields as the same process, you can do it to have the data on the vertical using Transpose tool.
This is the result and setting of Multi-row formula tool.
After that, you can do it to the original form using Cross Tab tool.
It works! Thank you very much!