Formatting formula results to summary format

Question

Hello,

I have got few results from multiple conditions in the workflow. I want to give the end user with the condition, result, field value for validating the outcome.

Input 123 - has all the conditions and field values

Output 123 - My output for the end user

Please note the comments are added for reference. I don't need the comments in output.

Can anyone assist on this.

Input 123.xlsx

Output 123.xlsx

Yoshiro_Fujimori · Answer

@Saravanan13 ,

It seems there is not enough information to decide which data should be moved to which column ("Tax Form1", "Tax Form2", "Application1", "Application2"..).

As I do not have the domain knowledge of tax forms, it is difficult to proceed.

If you can define which output column each row of the input data should be moved to, that might help.

Saravanan13 · Answer

Hello Yoshino,

Thanks for the reply.

I already have the formulas included for the conditions in the workflow. Just I need the output format as per the output file attached.

Yoshiro_Fujimori · Answer

Hi @Saravanan13 ,

Here is one way of doing this.

Workflow

As it is easier to compare values, I "Cross Tab"ed the table and used Formula tool.

Output

Some questions are not clear enough to answer.(as highlighted below)

If you know the definition, you can add the necessary fields with "Select" tool and generate answer with "Formula" tool.

Good luck.,

Questions.yxmd