Prepping Data from 4 reports

aberthiaume

Hi There, 

I am trying to take data from 4 reports and join them.  I have successfully done so I believe, but now I want 1 row for each unique ID and Date.  

Currently I have one row for each report by unique ID and Date.   It looks something like this... See Attached Spreadsheet.  I Tried transpose and cross tab and those didn't work.  I know there is an easier way.  

Thanks! 

Sample for Alteryx Question .xlsx

benakesh

Hi  @aberthiaume ,

To create 1 row for each unique ID and Date it is easier  to start with  4  input reports .

Can  you attach  4 input sample reports  ?  Small  subset of data  is good  instead  of full data . 

The wf  extracts  data  for  each report  and  combines  data for each id and date .

Hope this helps.

4reports.yxzp