Re: Permutations - 8 columns

From: Tim Williams (saxifrax_at_pacbell*dot*net)
Date: 02/21/05 

Date: Sun, 20 Feb 2005 16:15:56 -0800

I took the OP's explanation to mean that owing to the "financial"
(sensitive?) nature of the data they were not permitted to make
complete "copies" of the data by extracting it whole...

Tim.

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eIKcyK5FFHA.548@TK2MSFTNGP14.phx.gbl...
> >We are not allowed to extract the information directly from the
> >database
>>in a tabular form.
>
> I suspect if he could query the database, he wouldn't need the
> combinations.
>
> Sounds like he is blindly querying the database with all possible
> combinations to get back any possible results that may exists.
>
> Just my guess of course.
>
> --
> Regards,
> Tom Ogilvy
>
> "Tim Williams" <saxifrax@pacbell*dot*net> wrote in message
> news:On92jq4FFHA.2568@TK2MSFTNGP10.phx.gbl...
>> Since you're using a database, why not just let SQL do the work ?
>>
>> select t.Period, t.account, t.currency, t.code, t.country,[other
>> columns here], sum(t.amount),average(t.amount)
>> from DataTable t
>> group by
>> t.Period, t.account, t.currency, t.code, t.country,[other column
>> here]
>>
>> Unless I misunderstand your explanation that should give you the
>> desired result.
>>
>> Tim.
>>
>>
>> <sanshah01@yahoo.com> wrote in message
>> news:1108890725.056729.169580@g14g2000cwa.googlegroups.com...
>> > Hi,
>> >
>> > I have gone through various posts in this group for the solution
>> > of
>> > a
>> > permutation I require but could not find one.
>> >
>> > The data I have is as follows in eight columns
>> >
>> > Col A Col B Col C Col D Col E ............ etc
>> > Period Account Currency Code Country ....... etc
>> > Nov-04 99700 USD 1234 USA
>> > Dec-04 51000 2270 EUR
>> > 61000 2568 IND
>> > 38000
>> >
>> > I need to have a macro which would give me a combination of data
>> > in
>> > various columns into a database format. There can be additions to
>> > the
>> > information in some of the columns for eg. incase a new account
>> > is
>> > created.
>> >
>> > The output on another *** needs to be as follows
>> >
>> > for eg.
>> > Col A Col B Col C Col D Col E ............ etc
>> > Period Account Currency Code Country ....... etc
>> > Nov-04 99700 USD 1234 USA
>> > Nov-04 99700 USD 1234 EUR
>> > Nov-04 99700 USD 1234 IND
>> > Nov-04 99700 USD 2270 USA
>> >
>> > Let me provide a background on why I am following this process
>> > since
>> > if
>> > someone has a better suggestion for arrive at the end result, I
>> > am
>> > open
>> > for it.
>> >
>> > We have a database where all the financial information is stored.
>> > We
>> > are not allowed to extract the information directly from the
>> > database
>> > in a tabular form. However using Excel retrieve I am allowed to
>> > extract
>> > the information based on various paramaters and unique variables
>> > of
>> > each parameter is being listed by me as shown in the first table.
>> >
>> > After having a permutation of various cols and parameters, I will
>> > be
>> > adding an amount column which would provide the information
>> > retrieved
>> > based on the unique combination of 8 columns / 8 parameters.
>> >
>> > Anyone's help is highly appreciated.
>> >
>> > Regards
>> > Sandip.
>> >
>>
>>
>
>