Could I possibly toggle the whole table by another.. is there a work around.. I'm trying all options but no joy... if you'd know of any would be great...

Thanks for this...

Ok I've tried inserting multiple tables within a rectangle and it exports fine in excel. But i'd like to toggle a table based on a cell from...

Thanks for the reply..

Do I place table within a table? If so I'm getting thi error message when exporting to excel

Data Regions within table/matrix cells are ignored.

Many thanks for your response.. I'd like to import from a excel file rather than export.. how do I assign the excel source to pick a dynamic filename name.. if...

Sorry but I'm not sure what you mean?? Do you mean why I'm not using a PK? Rate_Uno is set as the PK.

I have one key as:

tablename3

2...

Rate_uno needs to be an incrementing and unique number e.g. max(rate_uno)+1.

How would I simply insert data and setting this column e.g. max(rate_uno)+1?

If I do something like the below how would I get the rate_uno to update??

insert into xxx (rate_uno, a, b, c)

select distinct (select max(rate_uno)+1 from xxx), a, b, c...

Ok please could you write me the simplest way to insert rows from one table to another and also I have a rate_uno column that needs to be unique how...

Thanks for your response.

I have two loops that inserts data into a table, they both work run fine. But if I run one after the other I get the error...

Hi,

Yes I did work out it was the text qualifier that I didn't set.

Thank you so much for all your help.

Much appreciated.

Many Thanks.

If I put double quotes around my values. I'm get double double quotes when I review the data.

Eg: When I have value "Orange, Plc" when I preview this in...

Ok so for example I have the below column with values:

Company Name

Orange, Plc

Vodafone

O2, Plc

If I extract the above, Orange, Plc and O2, Plc values with commas will be treated as...

Thanks for your response.

I am trying to import data from Company Name column in CSV file that contains commas in the value.

E.g. Company name could be = Orange, Plc

When I...

Thanks for your reply.

I've used the below expression and that removes hyphen with NULL.

[column name] == "-" ? NULL(DT_WSTR,4) : [column name]

That worked for me.

Thanks anyways.

How can I amend this expression to replace it to NULL rather than "" (a space)?

REPLACE([Column_name],"-","")

All help will be appreciated?

Many Thanks.