Question About Multi-Field Formula

[tamluenwai29]

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. 

[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.)

[apathetichell]

formula tool

formula 1

if [f1]="booth" then "monthly two" elseif [f1] = "monthly activities" then "booth" else [f1] endif

formula 2

- use the same idea to set monthly two to monthly activities.

fix this to reflect your actual field values. use formula 3 to reset recordid as needed.

[flying008]

Hi, @tamluenwai29 

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