Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Copy same setting from one user to another in the same group

k3pineapple
8 - Asteroid

Hello All 

 

I would like to build a flow in order to copy settings from one user to another within the same group, and formula can apply in all groups in one sheet..

 

Sample input and output provided below:

 

Input:

 FirmUserProductBuySellHold
1ABCAMYAppleYesYesNo
2ABCBET

Apple

NoNoNo
3ABCAMYBananaYesNoYes
4ABCCATBananaNoNoNo
5DEFENNAppleNoYesYes
6DEFFRANKAppleNoNoNo
7GHIGEOBananaNoNoYes
8GHIHENRRYBananaNoNoNo

 

 

Output:

 FirmUserProductBuySellHold
1ABCAMYAppleYesYesNo
2ABCBET

Apple

YesYesNo
3ABCAMYBananaYesNoYes
4ABCCATBananaYesNoYes
5DEFENNAppleNoYesYes
6DEFFRANKAppleNoYesYes
7GHIGEOBananaNoNoYes
8GHIHENRRYBananaNoNoYes

 

Thank you very much.

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @k3pineapple,

Here is one way to do this:

IraWatt_0-1657100844043.png

The sample tool takes the first element from each group. Then the join tool adds that elements settings to all others in that group.

Any questions or issues please ask :)
HTH!
Ira

 

grazitti_sapna
17 - Castor

Hi @k3pineapple, another way of solving this problem.

grazitti_sapna_0-1657101398685.png

 

 

Thanks!

Sapna Gupta
binuacs
20 - Arcturus

@k3pineapple one way of doing this

binuacs_0-1657106163410.png

 

 

k3pineapple
8 - Asteroid

Hi @IraWatt , Thanks for your solution.

 

I found out if there is over 2 users has the same settings,  will also pop up in the out folder.

E.g.:

 FirmNameProductBuySellHold 
1ABCAMYAppleYesYesNo 
2ABCBET

Apple

NoNoNo 
3ABCCHARLIE

Apple

YesYesNo 

 

the output will have 3 rows as well, but i only want two rows, one of them is the row which has been changed. Sample output:

 FirmNameProductBuySellHold 
1ABCAMYAppleYesYesNo 
2ABCBET

Apple

YesYesNo 

 

Is this "Sample" Function still work?

IraWatt
17 - Castor
17 - Castor

Hey @k3pineapple,

Im not sure why the third row needs to be removed. Does the workflow not just apply the same user settings to everyone in the same group?

 

 

Labels