Grouping by data section

[Moe-Sado]

Hi,

I would like to know how I can group in alteryx the data corresponding to the VAT identification section in a new column.

As seen in the following table:

Previous information
DATA	FIELD_1
VAT ID	123
COMPANY	Example Co.
DATE	2017-04-30
SALES	10
VAT ID	234
COMPANY	Example INC.
DATE	2017-05-30
SALES	11
PURCHASES	3
VAT ID	123
COMPANY	Example Corp.
DATE	2017-07-30

Desired information
DATA	FIELD_1	GROUP
VAT ID	123	1
COMPANY	Example Co.	1
DATE	2017-04-30	1
SALES	10	1
VAT ID	234	2
COMPANY	Example INC.	2
DATE	2017-05-30	2
SALES	11	2
PURCHASES	3	2
VAT ID	123	3
COMPANY	Example Corp.	3
DATE	2017-07-30	3

[Luke_C · Accepted solution]

Hi @Moe-Sado 

here's an example using the multi-row formula tool. It looks to see if the value is VAT ID, if it is, then it adds 1 to the group, otherwise repeats the previous group number.

[Jonathan-Sherman · Accepted solution]

Hi @Moe-Sado,

You could use a multi-row to check the value of your [Data] field. If it = VAT ID then add 1 to the value from the above row:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan