When importing an Excel file, which contains merged cells, Alteryx only recognises the value of the first merged cells and not all the cells which are merged. I am attaching an example of it. Is there any solution inside Alteryx (without prior Excel data manipulation) which would consider that all the cells within merged range have a value?
Thank you,
Gorazd
Solved! Go to Solution.
Hi @Oz
I would solve this issue by using a Multi-Row Formula with this formula: IF ISNULL([F1])THEN [Row-1:F1] ELSE [F1] ENDIF
The module is attached.
Hope this helps,
Joe
Have you done something similar with merged columns?