Group Functions/ Cross/ Transpose

Question

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

UserGroupLeadGroup_id_leadIdbookingValueconfirmedinsertDateitinerary00user_id_1lead_id_12538002024-03-18Chennai (TN) only01 lead_id_2843602024-05-14Chennai (TN) only02 lead_id_33374612024-03-18Chennai (TN) only03 lead_id_4843612024-03-18Chennai (TN) only04 lead_id_54218202024-06-17Chennai (TN) only05 lead_id_63796412024-03-18Chennai (TN) only10user_id_2lead_id_12480712024-04-23Delhi (DL) only11 lead_id_21206512024-04-23Delhi (DL) only

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

UserGroupLeadGroup_id_leadIdbookingValueconfirmedinsertDateitinerary00user_id_1lead_id_12538002024-03-18Chennai (TN) only01user_id_1lead_id_2843602024-05-14Chennai (TN) only02user_id_1lead_id_33374612024-03-18Chennai (TN) only03user_id_1lead_id_4843612024-03-18Chennai (TN) only04user_id_1lead_id_54218202024-06-17Chennai (TN) only05user_id_1lead_id_63796412024-03-18Chennai (TN) only10user_id_2lead_id_12480712024-04-23Delhi (DL) only11user_id_2lead_id_21206512024-04-23Delhi (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.

sampleWorkflowQuery.yxmd

DataNath · Accepted Answer

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 Answer

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

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