How to search for a value in a column, and then export the whole row into a new excel

[LukePick]

Hi, 

I have just combined 12 months of multiple customers data into one file, of which I now want to randomly select a sample of customers from, and get a report of all of the rows in the (12 month file) which relate to them.

Essentially, I want to import a document that has 16 randomly selected customer ID's, compare those against my large 12 month data set, and output all of the rows of data into a new file - filtering by the 'customer ID' column - of which will allow me to see just the 12 months of activity for the sampled customers. 

Is there a way of doing this in Alteryx? I have tried in excel but the data set is too large and I am unable to sort it! 

Thanks! 

[AndrewDMerrill]

All you need to do is use the Join Tool to connect the two datasets together on Customer ID. Use the 'J' output anchor for desired data output.

Happy Solving!

[LukePick]

Hi Andrew, 

Thank you for your response.

All fixed! Thank you for your help! :)