Group Functions/ Cross/ Transpose

[awanishyadavv]

This is my workflow output----------------

UserGroup	LeadGroup	_id	_leadId	bookingValue	confirmed	insertDate	itinerary
0	0	user_id_1	lead_id_1	25380	0	2024-03-18	Chennai (TN) only
0	1		lead_id_2	8436	0	2024-05-14	Chennai (TN) only
0	2		lead_id_3	33746	1	2024-03-18	Chennai (TN) only
0	3		lead_id_4	8436	1	2024-03-18	Chennai (TN) only
0	4		lead_id_5	42182	0	2024-06-17	Chennai (TN) only
0	5		lead_id_6	37964	1	2024-03-18	Chennai (TN) only
1	0	user_id_2	lead_id_1	24807	1	2024-04-23	Delhi (DL) only
1	1		lead_id_2	12065	1	2024-04-23	Delhi (DL) only

This is what I want in output from workflow-------------------

UserGroup	LeadGroup	_id	_leadId	bookingValue	confirmed	insertDate	itinerary
0	0	user_id_1	lead_id_1	25380	0	2024-03-18	Chennai (TN) only
0	1	user_id_1	lead_id_2	8436	0	2024-05-14	Chennai (TN) only
0	2	user_id_1	lead_id_3	33746	1	2024-03-18	Chennai (TN) only
0	3	user_id_1	lead_id_4	8436	1	2024-03-18	Chennai (TN) only
0	4	user_id_1	lead_id_5	42182	0	2024-06-17	Chennai (TN) only
0	5	user_id_1	lead_id_6	37964	1	2024-03-18	Chennai (TN) only
1	0	user_id_2	lead_id_1	24807	1	2024-04-23	Delhi (DL) only
1	1	user_id_2	lead_id_2	12065	1	2024-04-23	Delhi (DL) only

I want _id to be populated in every row, based on UserGroup------------

I have attached my workflow for review, I am new to Alteryx designer, I am not sure how to do that??
Workflow contain data input.

Any help is really appreciated.

[DataNath · Accepted solution]

Hey @awanishyadavv, great start here and thanks for providing a detailed description, as well as your current workflow! We just needed one more step - using a Multi-Row Formula tool in order to fill down the missing values like so:

The expression itself is:

IF [UserGroup]=[Row-1:UserGroup] THEN [Row-1:_id] ELSE [_id] ENDIF

Which just tells Alteryx: If the [UserGroup] is the same as the previous row's, copy the [_id] down. If not i.e. when the [UserGroup] value changes, take that in the current row. Hope this helps!

[awanishyadavv · Accepted solution]

I got this resolved: IIF(IsEmpty([_id]),[Row-1:_id],[_id])

Yours is also true. Thanks for the response. @DataNath