Skip to main content

Question regarding Summarized Data

Hi,
 Is it possible to get the base population file in case we are provided with only Summarized data? It is taking time to extract each summarized data (by cliking oin the number of records hyper link)and finally we need to append. Is there any easier way to do the same?. Thanks, Bibin

Brian Element Wed, 10/26/2016 - 09:00

Hi Bibn,

Yes there is.  You can use a join.  It sounds like you don't want to extract all the transactions for the summarized data but only a portion?  What I would do is create a boolean field in your summarized data file.  I would then indicate which records I want to extract.  I then create an extract file from your summary file of all the items that I am interested in.

Next I would do a join.  Your transaction file would be your primary and your secondary file would be the extract you just created.  The join field would be the summarized field and you would use the matches only option.  This will give you a new file of all the transactions that you are interested in.

Good luck.

Brian

bbaburaj Thu, 10/27/2016 - 06:13

Hi Brain,
 
Thanks for the quick response but my question is we are provided with only a summarized file. The full population is not provided. My question is can we recreate the total population using the summarized file?.
 

Brian Element Thu, 10/27/2016 - 07:40

Hi Bibin,

I guess I am not understanding something.  From your first post you said you had the summary file and were clicking on the number of records link to get the source transactions.  In order to do that you need the detail file so if you don't have the total population I am not understanding what you are linking back to. 

Do you not have the file that the summary was created from? 

Thanks

Brian