Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Group Functions/ Cross/ Transpose

awanishyadavv
7 - Meteor

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

UserGroupLeadGroup_id_leadIdbookingValueconfirmedinsertDateitinerary
00user_id_1lead_id_12538002024-03-18Chennai (TN) only
01 lead_id_2843602024-05-14Chennai (TN) only
02 lead_id_33374612024-03-18Chennai (TN) only
03 lead_id_4843612024-03-18Chennai (TN) only
04 lead_id_54218202024-06-17Chennai (TN) only
05 lead_id_63796412024-03-18Chennai (TN) only
10user_id_2lead_id_12480712024-04-23Delhi (DL) only
11 lead_id_21206512024-04-23Delhi (DL) only

 

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

UserGroupLeadGroup_id_leadIdbookingValueconfirmedinsertDateitinerary
00user_id_1lead_id_12538002024-03-18Chennai (TN) only
01user_id_1lead_id_2843602024-05-14Chennai (TN) only
02user_id_1lead_id_33374612024-03-18Chennai (TN) only
03user_id_1lead_id_4843612024-03-18Chennai (TN) only
04user_id_1lead_id_54218202024-06-17Chennai (TN) only
05user_id_1lead_id_63796412024-03-18Chennai (TN) only
10user_id_2lead_id_12480712024-04-23Delhi (DL) only
11user_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.

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

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:

 

zyx.png

 

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
7 - Meteor

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

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

Labels
Top Solution Authors