Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have four fields that i want to group as 1 field but can't find the solution. see attached image
I attached a sample qvw file for your reference.
Thank you!
any idea?
please help..
I'm not sure I follow what your issue is, can you give me some more info as to what you're trying to achieve?
I have four fields in which i want to consolidate into a single field but that single field is arrange based on the order of each fields.
for example
Level1 Field
Level2 Field
Level2 Field
Level3 Field
Level1 Field
Level2 Field
Level3 Field
Maybe I'm still not getting it but can you not just amend your initial laod to concatenate the fields into one (I've not catered for if the fields are nullable)
FinalPandLTable:
LOAD Account,
DateKey,
[Detailed Account Mapping],
[Account Groupings],
[P&L Groupings],
[Major P&L Groupings],
[Major P&L Groupings Seq],
[P&L Groupings Seq],
[Account Groupings Seq],
[Detailed Account Mapping Seq],
[Major P&L Groupings]+[P&L Groupings]+[Account Groupings]+[Detailed Account Mapping] as GroupedField
FROM
FinalPandLTable.qvd
(qvd);
if i concatenate the fields it will not give me the result that i want .
I want to have that in a single field so that i can use it in a pivot table.
have you seen the summary table in the script window?
Oh I think I'm understanding what you're getting at, you want to be able to select in the same field - can you group the fields so that you can select which level to pick and then pick within the level?
Hi Mars
did that query solve ur problem?
Note: by that solution u can select all ur required dimensions individualy or togather in one field.
u welcome for next.
No sir,
Hi,
Right click on sheet - select multibox - add dimensions - apply - OK
by this solution a multibox is created and u can find all selected fields in one box.
plz find attachment
is this not your solution, Mars?
with regards
Ajeet singh