Reload Excel file with duplicate field name

[#1]

Hi all:

I want to load in data from an excel file.

The excel file is autogenerated overnight from a system. I understand that having two different fields with same name is not the best practice for database. But they are from other department and for now I don't have any control over the field name.

There are two fields both called 'Status' but containing different data.

How can I load both fields into Qlikview?

Thank you very much.

Paco

[#2]

Ah...

I see what you mean. I think this could work.

Thank you very much.

PC

[jmmayoral3]

Hi.

Pay Attention that Max Dreammer´s  script loads the headers in the first record as they where data.

Use theese script to load an auxiliar table (for example: excel_aux)

and just after load the true table:

Name_Table:

LOAD *

RESIDENT excel_aux

WHERE Status <> 'Status';

Drop table excel_aux;

[PrashantSangle]

Hi,

If you see my script in that initially I load all headers as data with explicit labels but you can see during transformation step. I am removing 1st row so that header value will not be loaded as data.

Regards

[jmmayoral3]

You're absolutely right. I didn´tt see it.

Sorry.

[Anonymous]

Hi,

Please can you upload sample data.

Regards

Neetha

[rwunderlich]

Your original question asked about "excel file". I assumed you meant .xls or .xlsx file -- which is where the auto renaming of columns works. It would not work with a csv file.

-Rob