comparing several files

[lerben]

Hi all,

I have following problem. I would like to compare several tables.

I have a short listed table 

Name	category	stage	Feature 1	Feature 2	Feature 3
A	AAA	aa	X	Y

that I would like to compare to a long listed table

Name	category	stage	Feature 1	Feature 2	Feature 3
D	AAA	bb	X	K
E	BBB	cc	X	Y	Z
F	AAA	aa	V	K	J
A	AAA	aa	X	Y

using a third table with feature relationships

Feature 1	Feature 2	Feature 3	Feature 4
X	Y	Z	K
V	K	J

the output should be the short listed table with additional columns

Name	category	stage	Feature 1	Feature 2	Feature 3	same_aa	same_bb	same_cc	related_aa	related_bb	related_cc
A	AAA	aa	X	Y		0	1	0	1	0	0

the additional columns should one based on the following criteria form the long list and feature relationship:

- exclude the one with the same name

- only consider lines within the same category

- sum up by stage names that have same or related features

- same feature is when the line has one of the same features

- related feature is when the line has a related feature based on the related features table (e.g. F is related to A) 

- lines considered as same should not be accounted in related any longer

Of course I have more than just one line / features etc.

I would be super helpful for some general input on how to compare different sheet, workflow would be of course appreciated too 🙂

Thanks, -L

[rkapoor]

@lerben have you tried to read in the individual sheets via separate Input tools.  Then join the data, apply your criteria and bring in the additional columns?

If you want, book a Virtual Session and we can get you started:

https://community.alteryx.com/t5/Virtual-Solution-Center/tkb-p/vsc

[lerben]

Thx, I got it solved in the mean time.

-L