Hi all! I have data that looks like this:
Name 1 | 40 |
44 | |
Name 2 | 23 |
25 | |
Name 3 | 70 |
76 | |
Name 4 | 54 |
45 |
I'm trying to get Alteryx to repeat the first column names--so it would end up looking like:
Name 1 | 40 |
Name 1 | 44 |
Name 2 | 23 |
Name 2 | 25 |
Name 3 | 70 |
Name 3 | 76 |
Name 4 | 54 |
Name 4 | 45 |
I think this would be done via a Multi-Row formula tool. However, my formula can only get it to repeat "Name 1" for every row, which isn't correct. Any ideas on how I can go about updating this correctly?
Solved! Go to Solution.
Hi @dataviolet
Here is a workflow for the task.
Input: As given
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Thank you for the fast solution. Looks like I was just missing a section to my formula--forgot the "else" part:
IIF(isempty([Column1]),[Row-1:Column1],[Column1])
Hi @dataviolet
My solution is also same and i posted first why didnt you mark my post as solution.
My formula is also same IIF(isempty([Column1]),[Row-1:Column1],[Column1])
and i added Trim to remove blank spaces as a extra safety measure.
Asking out of curiosity
I appreciate your assistance! Your solution worked too, but was confused about the necessity of the TRIM function used:
IIF(isempty(Trim([Field1]," ")),[Row-1:Field1],[Field1])
I thought the simpler method was without the TRIM
Hi @dataviolet
Trim([column]," ") is used a safety measure to remove blank spaces just in case you have multiple spaces
(like " ") as blank.
Just be on a safer side🙂
You are allowed to mark multiple post as solution so please mark mine also if you dont mind 🙂
thank you for the explanation! that makes sense--in fact, i did have to use a data cleanse tool prior to this multi-row function, but now with the TRIM function, looks like I can get rid of the data cleansing tool.
Yup thats the purpose to remove surrounding spaces
Happy to help 🙂
Cheers and Happy Analyzing 😀