Unmerge Cell for Formulas & Dynamic Output.

[ptomas]

Hi Alteryx Community!

I need to create an output file that can be dynamically changed. I am looking to do an excel formula in the output so that someone else can make changes on the excel output and have the total sum and verbiage change accordingly; for instance:

Typologies	Score	Description
Typology 1	2	Verbiage (For Score 2)
Typology 2	5	Verbiage (For Score 5)
Typology 3	8	Verbiage (For Score 8)
Total	15

Each score has a unique verbiage associated with that number. I want it so that when people change the score either manually or through a "slider" and corresponding description will change to it's associated number.

Furthermore I want to encorporate a formula for the total which automatically takes the sum of the scores above. I am unable to do this as the cells for scoring are two collumns merged. As such, I have two questions.

1) How do I unmerge cells so that I can create a formula to calculate the sum total?

2) Is it possible to create a dynamic output where the the description will change to it's associated score?

Thanks Alteryx Community :)

[KGT]

OK, so looking at the table you have in the question and using that as the example, you are trying to write out 3 columns:

• Typologies is an identifier
• Score is a number that the workflow will calculate (and someone may update later)
• Description is a text result based on the score.

From what I understand, you would like the Description field to be a formula, so that when someone updates the score in the spreadsheet, then that field will change?

When you use the Output Tool, you are outputting a data table, not a report. This is important in thinking about what you are trying to accomplish. Although you can write out the text that is required in that cell for the formula (e.g. "=Vlookup(VerbiageList!A1:A9,B1:B9...)"), Excel needs to recognise that as a formula and calculate it on open of the workbook, and that's where it can be tricky.

Generally, when trying to achieve this task, your first option to test is whether you can just write out the first 2 columns to a range in the spreadsheet (such as C:\Output Test.xlsx|||'Test1$A1:B3'), and have the 3rd column already be the required formula. I highly recommend investigating that, especially if you are going to have other things on the sheet such as sliders. The other way to do this, is write out to a "data" sheet and have all three columns be formulas that refer to that datasheet.

As for the unmerging part, I'm not sure what that is in reference to. The cells won't be merged in Alteryx, and if they are merged in an excel sheet with the results in it, that's an excel operation, that would require calling Excel via Python/R/Powershell etc to change something (not entry level).