HI team, Looking for a flow/Macro that can generate output To Generate missing product for all users. Many Thx Input CompanyBranchProductCodeStatusLoginCountABCAA123AEnabledA1232ABCAB123AEnabledA1232ABCAA123AEnabledB1231ABCBA123AEnabledC1232ABCBC123AEnabledC1232DEFAA456BEnabledD1232DEFAC456BEnabledD1232DEFBC456BEnabledE1231 Output CompanyBranchProductCodeStatusLoginABCAC123AEnabledA123ABCAB123AEnabledB123ABCAC123AEnabledB123ABCBB123AEnabledC123DEFAB456BEnabledD123DEFBA456BEnabledE123DEFBB456BEnabledE123 Product Identify Macro.xlsx

Perhaps something like this? Br (ツ) Thomas

Marco to find desired missing data

HI team,

Looking for a flow/Macro that can generate output

To Generate missing product for all users. Many Thx

Input

Company	Branch	Product	Code	Status	Login	Count
ABC	A	A	123A	Enabled	A123	2
ABC	A	B	123A	Enabled	A123	2
ABC	A	A	123A	Enabled	B123	1
ABC	B	A	123A	Enabled	C123	2
ABC	B	C	123A	Enabled	C123	2
DEF	A	A	456B	Enabled	D123	2
DEF	A	C	456B	Enabled	D123	2
DEF	B	C	456B	Enabled	E123	1

Output

Company	Branch	Product	Code	Status	Login
ABC	A	C	123A	Enabled	A123
ABC	A	B	123A	Enabled	B123
ABC	A	C	123A	Enabled	B123
ABC	B	B	123A	Enabled	C123
DEF	A	B	456B	Enabled	D123
DEF	B	A	456B	Enabled	E123
DEF	B	B	456B	Enabled	E123

Product Identify Macro.xlsx

Output

Macros

Dynamic Processing

Accepted answers

Verakso

Perhaps something like this?

2024-06-07 12_49_13-Alteryx Designer x64 - Missing data.yxmd.png

Br (ツ)

Thomas

Missing data.yxmd

All comments

Raj

@k3pineapple
can you please explain the logic

Verakso

Perhaps something like this?

2024-06-07 12_49_13-Alteryx Designer x64 - Missing data.yxmd.png

Br (ツ)

Thomas

Missing data.yxmd

jdminton

@k3pineapple I don't think you've provided enough information. Also, your data generalization is probably going to cause problems. For example, I doubt that the same branches exist in different companies. Also, there is no way for us to know if status, code, or count are relevant for this. Can you clean up the sample data and provide more information on what you're needing?

Raj

@k3pineapple
is this solved?

if not please share the logic for this.

k3pineapple

@Raj above flow works

k3pineapple

Appreicated

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335