topic Re: Copy same setting from one user to another in the same group in Alteryx Designer Desktop Discussions

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

k3pineapple — Wed, 06 Jul 2022 09:33:43 GMT

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:

	Firm	User	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	No	No	No
3	ABC	AMY	Banana	Yes	No	Yes
4	ABC	CAT	Banana	No	No	No
5	DEF	ENN	Apple	No	Yes	Yes
6	DEF	FRANK	Apple	No	No	No
7	GHI	GEO	Banana	No	No	Yes
8	GHI	HENRRY	Banana	No	No	No

Output:

	Firm	User	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	Yes	Yes	No
3	ABC	AMY	Banana	Yes	No	Yes
4	ABC	CAT	Banana	Yes	No	Yes
5	DEF	ENN	Apple	No	Yes	Yes
6	DEF	FRANK	Apple	No	Yes	Yes
7	GHI	GEO	Banana	No	No	Yes
8	GHI	HENRRY	Banana	No	No	Yes

Thank you very much.

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

IraWatt — Wed, 06 Jul 2022 09:48:48 GMT

Hey @k3pineapple,

Here is one way to do this:

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

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

grazitti_sapna — Wed, 06 Jul 2022 09:56:54 GMT

Hi @k3pineapple, another way of solving this problem.

Thanks!

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

binu_acs — Wed, 06 Jul 2022 11:16:16 GMT

@k3pineapple one way of doing this

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

k3pineapple — Mon, 11 Jul 2022 06:41:48 GMT

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.:

	Firm	Name	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	No	No	No
3	ABC	CHARLIE	Apple	Yes	Yes	No

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:

	Firm	Name	Product	Buy	Sell	Hold
1	ABC	AMY	Apple	Yes	Yes	No
2	ABC	BET	Apple	Yes	Yes	No

Is this "Sample" Function still work?

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

IraWatt — Mon, 11 Jul 2022 16:07:21 GMT

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?