Thanks Phil .. I was googling just that! Thank you 🙂

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...

Apologies for not being clear .. it has been re-written..

Source Data Structure:

TABLE_A:

ID Rank2 sysno Rank1

10844 2 18178 1

10844 4 27529 2

10845 1 22994

10845 3 22129

1. I want to 'pivot' the data by having the one line for each ID value.

2. New...

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...

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...

Thanks Jim, I will try out your code .. I had a basic CASE statement structure ..

Hi Sean,

That's not an option as data will be copy pasted across from various data sources directly into the table.

HI Drew,

can I have a join in a CASE statement?

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...

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...

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...

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...

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...

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...

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?...