Viewing 15 posts - 31 through 45 (of 45 total)
Thanks Phil .. I was googling just that! Thank you 🙂
April 10, 2012 at 9:12 am
Hi Phil,
Many thanks! Thank you I have learned a new way of thinking and looking at things when I saw your reply. I will try and replicate your query and...
April 10, 2012 at 9:05 am
Apologies for not being clear .. it has been re-written..
Source Data Structure:
TABLE_A:
IDRank2sysnoRank1
108442181781
108444275292
10845122994
10845322129
1. I want to 'pivot' the data by having the one line for each ID value.
2. New...
April 10, 2012 at 9:02 am
Thank you for your reply.both the source and the destination are sequel server database tables.
The sequence containers are at present set to run in parallel, I am not sure how...
March 16, 2012 at 2:26 pm
Hi Eliott,
Many thanks for your reply
I have a series of csv files where I need to
1. search for a string say 'ZZZ' in column B.
2. Copy a string from...
December 9, 2011 at 9:49 am
Thanks Jim, I will try out your code .. I had a basic CASE statement structure ..
December 5, 2011 at 9:28 am
Hi Sean,
That's not an option as data will be copy pasted across from various data sources directly into the table.
December 5, 2011 at 9:22 am
Hi .. I have written it out with CASE statements but if I could sort out the one issue where the variable is going wrong then I could get the...
December 5, 2011 at 9:12 am
Thanks Drew, yes I need them in one column and I have too many columns to utilise the CASE statement. Going forward for a non-technical person to maintain it or...
December 5, 2011 at 9:10 am
Hi Jim,
Many thanks for your help. I should have mentioned I have gone down the route of CASE statements .. but there are far too many columns to look up...
December 5, 2011 at 9:05 am
I have tried your code ... many thanks again .. it works great but it returns multiple rows with 'Error Messages'.
For my purposes I would want to have the...
December 5, 2011 at 8:20 am
Hi Lowell,
Many thanks for the code .. I am looking to loop as I will have a number of such columns and I will want to concatenate the error messages...
December 5, 2011 at 8:18 am
First of all many thanks for your support on this.
I have since tried to simplify my model as much as possible.
I have 7 distinct individual folders, I have created...
November 21, 2011 at 4:08 am
Hi Sam,
Many thanks for your reply. The answers to your questions are as follows:
1. Do you want to load a few files occasionally, or a large amount of files regularly?...
November 18, 2011 at 2:14 am
Viewing 15 posts - 31 through 45 (of 45 total)