Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to represent data in an intermediate version between the pivot table and a straight table?
Can you detail your requirements with an example?
Kiran.
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
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;
Instead of [{d}] Try '$(d)'
Kiran.
Thanks Kiran .
You help me very much .
Best regards Vilgis