Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload Excel file with duplicate field name

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

15 Replies
sunny_talwar

You can force them to be loaded with different names

For example

LOAD Status as Status_DepartmentName1

          ....

Resident Excel1

LOAD Status as Status_DepartmentName2

          ....

Resident Excel2

This way you won't have two fields with the same name.

I hope that this is what you are looking for, if not please clarify and some one might have a solution for you.

Best,

S

Not applicable
Author

Hi S:

Thank you very much for your reply.

I should clarify that I am loading one excel file. And there are two different fields with same name in the same excel file. And the field has nothing to do with 'Departments'. It is just that the data is provided by other departments, not the department I am in.

I try to rename one of the 'Status' field (lets say I rename to 'Status_new') but the result is both 'Status' and 'Status_new' are the same field. So one of the original 'Status' field are ignored.

Hope this would help you understand the data.

PrashantSangle

Hi,

Post your script, before doing modification.

and if possible post your sample excel file.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
avinashelite

Hi,

Please post your app and excel file , its hard to guess how is the data and fields

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The excel load has a bit of magic. If you use the "embedded labels" option, the first column labeled "Status" will be known as "Status". The second column labeled "Status" will be known as "Status1". So a generated LOAD statement, or one you code yourself will look like:

LOAD

     Status,

     Status1

From xxx (biff, embedded labels,,,)

;

Even though both columns have the heading "Status".

-Rob

Not applicable
Author

Hi Rob:

Thanks for your advice.

But my autogenerated script didn't automatically change the second field to 'Status1'.

And when I change it manually, it said it didn't recognise the field.

Here is an example of my excel file:

manojkulkarni
Partner - Specialist II
Partner - Specialist II

Check below script.

LOAD Status,

     [ID Number],

     [Full Name],

     [Record Type],

     Status AS Status1,

     [Hours Code],

     [Hours Description],

     [A/D Code],

     [A/D Code Description],

     [Date From],

     [Date To],

     [Return To Work],

     Hours

FROM

[Sample File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Not applicable
Author

Hi:

Have you tried your code?

It doesn't work for me...

Thanks

PC

PrashantSangle

Hi,

There is no direct way to acheive this.

You can try like with explicit labels

try below code

LOAD

@1 as Status,
@2 as [ID Number],
@3 as [Full Name],
@4 as [Record Type],
@5 as Status1,
@6 as [Hours Code],
@7 as [Hours Description],
@8 as [A/D Code],
@9 as [A/D Code Description],
@10 as [Date From],
@11 as [Date To],
@12 as [Return To Work],
@13 as Hours
FROM

(
txt, codepage is 1252, explicit labels, delimiter is ',', msq, filters(
Remove(Row, Pos(Top, 1))
));

REgards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂