Discussions

Make a bigger impact. Our Alteryx for Good Community is all about learning from one another, exchanging ideas, and collaborating.
This board is for asking questions or having discussions about the ADAPT Program and Alteryx for Good. If you have a question about Alteryx tools, need help with installation, or otherwise have product-related questions, please post in the Alteryx Designer Discussion Board .

Exercise 2 ADAPT Programme

Highlighted
8 - Asteroid

Hi Guys,

 

I know in the exercise we eliminate Customer ID 787 as it is duplicated, but how do we know that the correct annual transactions is 86? It could be 100 (as in the second file record associated with Customer ID 787).

 

And how do we select it if we know the second one is the correct value to use? Is the default the "first" read item per ID??

 

I know it is a practice exercise, but maybe you could have used exact duplicates? Although I also know that not using exact ones piqued my interest more, so thank you!!

 

Thanks!

 

Kirsty

Alteryx Certified Partner

Hi @KirstyHarvey ,

 

I don't have access to the program but the situation you explain is interesting. Do you have a workflow to share ?

 

Cheers,

 

Jean-Baptiste

Highlighted
6 - Meteoroid

here it is

Highlighted
Alteryx Certified Partner

Hi @ankursamadhiya ,

 

Do you have the source files needed ?

 

Cheers,

 

Jean-Baptiste

Highlighted
6 - Meteoroid

Yes, here they are.

 

Files 'Start2.1.yxdb' and 'Start 2.2.yxdb' are source files.

Solution supposed to match 'Final State - Excercise 2.yxdb'.

 

Highlighted
Alteryx Certified Partner

Thank you @ankursamadhiya ,

 

I'll check it !

 

Cheers,

 

Jean-Baptiste

Highlighted
Alteryx Certified Partner

Hi @KirstyHarvey ,

 

I checked and there is nothing to tell you which row to choose. At this point, you only have to choose following the logic you want but it would be good if rows were exactly the same.

 

@AFG_Team , is there anyway to modify the data from the exercise ?

 

Cheers,

 

Jean-Baptiste