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

[#1]

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.

[#2]

You can renames the different field names into common field name

[#3]

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.

[#4]

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

[#6]

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.

[#7]

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 · Accepted solution]

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

into

hope this helps

regards

Marco