Discussion Board for collaboration on QlikView Scripting.
I am facing an issue while creating a logic. Require your help
The logic behind the output is very easy.
Thanking you all in anticipation
Go to Solution.
See attached and let me know if this helps
If you explain the logic behind the output (that you say it's easy), it would be easier to help. I couldn't find the pattern.
Can you explain the logic so people don't spend time guessing!
BUT YOU NEED TO TELL US WHAT IT IS!
Crystal ball is not working today!
Sorry Guys (@awhitfield, @vinieme12, @eduardo.sommer ) for that lame line; 'Logic behind it is very easy'.
Please see the below image, it is very informative and explains the logic .
The Order of input data will not change. This data would come from SAP
This Tree diagram is not informative nor is it explaining the derivation of the node elements!
Can you explain how each item is evaluated?
for example: 4_3_2_4_4_1 and 4_3_2_6_2_2 ??
Temp: LOAD A,Autonumber(RowNo(),A) As NR,AutoNumber(A) as Level,RowNo() As Rowno Inline [ A 1 2 2 2 2 3 3 3 3 4 2 2 3 3 4 4 ];
Load Rowno,A,If(Level > 2,NewA&AutoNumber(RowNo(),NewA),NewA) as NewA; LOAD A,Level,Rowno, If(Level = 1,A, If(Level = 2,A&'_'&NR, If(Peek(A) <> A,A&'_'&Peek(NewA)&'_',Left(Peek(NewA),Len(Peek(NewA))-1)))) as NewA Resident Temp; Drop Table Temp;
Nice ; but I'd generally avoid Preceding load
Thanks vinieme12 for your quick reply,
actually i was able to achieve the same ouput with a similar type of code but the problem here is its not a dynamic code, what if someday 5 is also added to the tree