Hi All, I am new to Alteryx, I got a problem that I think it should related to multi-row formula tools. Here's my raw data: F1F2F3F4F5F6Month[Null][Null][Null][Null][Null]Monthly Activities 101102103104105- Booth[Null][Null][Null][Null][Null]- Advertisement 201202203204205 - Guest301302303304305 Expected Output: F1F2F3F4F5F6Month[Null][Null][Null][Null][Null]Monthly Activities [Null][Null][Null][Null][Null]- Booth101102103 104105- Advertisement 201202203204205 - Guest301302303304305 The reason of why this problem occurred is because value in F2, F3 etc... are merged cells in row Monthly Activities and - Booth. Thanks all of you.

Question About Multi-Field Formula

Hi All,

I am new to Alteryx, I got a problem that I think it should related to multi-row formula tools. Here's my raw data:

F1	F2	F3	F4	F5	F6
Month	[Null]	[Null]	[Null]	[Null]	[Null]
Monthly Activities	101	102	103	104	105
- Booth	[Null]	[Null]	[Null]	[Null]	[Null]
- Advertisement	201	202	203	204	205
- Guest	301	302	303	304	305

Expected Output:

F1	F2	F3	F4	F5	F6
Month	[Null]	[Null]	[Null]	[Null]	[Null]
Monthly Activities	[Null]	[Null]	[Null]	[Null]	[Null]
- Booth	101	102	103	104	105
- Advertisement	201	202	203	204	205
- Guest	301	302	303	304	305

The reason of why this problem occurred is because value in F2, F3 etc... are merged cells in row Monthly Activities and - Booth.

Thanks all of you.

Workflow

Developer

Designer Cloud

Regex

Macros

Apps

Batch Macro

Join

Interface Tools

Chained App

Iterative Macro

Accepted answers

flying008

Hi, @tamluenwai29

Another way for this case with no multiple-field formula.

录制_2024_10_14_13_50_34_639.gif

录制_2024_10_14_13_54_26_610.gif

All comments

Gawa

hi @tamluenwai29

Yes, the Multi Row Formula tool will work.

I suppose you are struggling with 'How to apply Multi Row Formula to multiple columns efficiently'.

If so, try Transpose & Cross-Tab like this. By using combo of Transpose & Cross-Tab, your WF will get so robust that accepts input data with dynamic schema(unknown # of columns, etc.)