Is it possible to represent data in an intermediate version between the pivot table and a straight table?

[#1]

Is it possible to represent data in an intermediate version between the pivot table and a straight table?

[#2]

Can you detail your requirements with an example?

Kiran.

[#3]

Hi Kiran .

My English is not good, but I try explain what I want to see.
In example
I get Data from function hierarchy in new table "TableOfHierarcy" .
And fields name1, name2, name3 ... may be n count.
Where field (name3, name4 or other) is empty, pivot table sum not represented.
I want create new table "TableOfHierarcy_2" with new fields by formula:

TableOfHierarcy_2.new_name1 = TableOfHierarcy.name1
TableOfHierarcy_2.new_name2 = TableOfHierarcy.name1 & ' ' & TableOfHierarcy.name2
TableOfHierarcy_2.new_name3 = TableOfHierarcy.name1 & ' ' & TableOfHierarcy.name2 & ' ' & TableOfHierarcy.name3

But I don't know how create this formula, because I don't know how much table "TableOfHierarcy" have fields (name1, name2,name3 and other)

Next step I want create new group from table "TableOfHierarcy_2"

Best regards Vilgis

[#4]

What wrong in this script?

TableOfHierarcy:hierarchy (ID, ParentID, Name, 'ParentName', Name, 'Path', '|', 'Depth')

load
     ID,
     ParentID,
     Name

resident TableOfNodes;

LET a = NoOfFields('TableOfHierarcy');

LET b = 1;

LET c = '';

LET d = '';

for b = 1 to a-6
     c = c & ' name' & $(b) & ' as new_name' & $(b) &' ,'
     NEXT

LET d = left(c,len(c)-1);    


TableOfHierarcy2:

load
     ID,
     ParentID,
     Name,
     ParentName,
     Path,

     [{d}],

     Depth

resident TableOfHierarcy;

[#5 · Accepted solution]

Instead of [{d}] Try '$(d)'

Kiran.

[#6]

Thanks Kiran .

You help me very much .

Best regards Vilgis