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