Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table loaded as follows:
LOAD NodeFullName, node_name, grdOrgId, hier_id, [Book Name] AS book_id, [Node Leve1 1], [Node Leve1 2], [Node Leve1 3], [Node Leve1 4], [Node Leve1 5], Depth, InstrumentFROM[Hierarchy.QVD](qvd);
I now want to extend this hierarchy by mapping the value for the field Instrument onto [Node Level X], where X=Depth+1.Note that we only have data for Node Levels 1-4, so no extra Node Levels need to be created.
Any suggestions are welcome!