Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
You can renames the different field names into common field name
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.
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
please post an example and your expected result.
regards
Marco
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.
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
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