Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I am using an excel spreadsheet as input to a QV Dashboard.

I am using an excel spreadsheet as input to a QV Dashboard.

The data stored in the spreadsheet is a concatenation of data from different InfoPath forms.  Consequently, I have more than 1 column that contains the same data, but under different column names.  Since it's not possible to go back into the InfoPath form and make the field names the same, what is the best/easiest way to load the 2 different columns with the same data, different column names, into 1 field for displaying on the QV DashBoard?  Thanks.

1 Solution

Accepted Solutions
MarcoWedel

second thought:

You could try like

table1:

LOAD ID,

    RangeMaxString([Partner Name], [Functinal Group]) as [Partner Name]

Inline [

ID,Partner Name,Functinal Group

1,text1

2,text2

3,text3

4,,text4

5,,text5

6,,text6

];

to transform your excel source from

QlikCommunity_Thread_204141_Pic2.JPG

into

QlikCommunity_Thread_204141_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

7 Replies
Not applicable
Author

You can renames the different field names into common field name

Not applicable
Author

I have a field name [Partner Name] and [Functional Group]  if I code

load

   [Partner Name],

   [Functinal Group] as [Partner Name],

I get duplicate name error.

How does Rename work?

Thanks.

Not applicable
Author

Steve,

You would want to change the data in the script as you're loading it in from your excel file.  You may have a load statement that looks like this:

Table:

LOAD Field1,

           Field2,

           Field3    

FROM

(biff, embedded labels, table is Page1_1$);

Change this part of the script:

LOAD Field1 as Field12,

           Field2 as Field13,

           Field3   

MarcoWedel

‌please post an example and your expected result.

regards

Marco

Not applicable
Author

I'm thinking I need to review what the data coming in on the table looks like.  Let me do some more research and I will get back to you as needed.  Thanks everyone for your help, and giving me some information to think about.

Not applicable
Author

I think you need to do

load

   [Partner Name] as [SOMETHING],

   [Functinal Group] as [SOMETHING ELSE],

You have "Partner Name" twice.

load

   [Partner Name],

   [Functinal Group] as [Partner Name],

When you don't specify an alias using "as", then the source field name will be used.  As you aliased the next field (Functional Group) as Partner Name, you are seeing the duplicate field error.

Regards,

Graeme

MarcoWedel

second thought:

You could try like

table1:

LOAD ID,

    RangeMaxString([Partner Name], [Functinal Group]) as [Partner Name]

Inline [

ID,Partner Name,Functinal Group

1,text1

2,text2

3,text3

4,,text4

5,,text5

6,,text6

];

to transform your excel source from

QlikCommunity_Thread_204141_Pic2.JPG

into

QlikCommunity_Thread_204141_Pic1.JPG

hope this helps

regards

Marco