Discussion Board for collaboration related to Qlik Education.
Hi guys, My input field is the following and
I need output in following way. in
Can anyone help me in this?
Load *, Len(Month) as Length Inline
Mid(Month,IterNo(),1) as Month
While IterNo() <= Length;
Drop table T1;
Hi Manish, thanks for your reply. But here i am getting the result as but I need out put as
AK 1 and
add an id in load, you can use it in straight table chart and hide
rowno() as id,
Hi Massimo, its not working as required. If u are getting it appropriately as I mentioned please share the Qvw.
Hi Rahul S,
As Massimo said it works just fine. I tried it on my machine.
It worked, thanks a lot.
When I worked on your question, i used IterNo() as id while iteration.. but by mistake has removed while uploading answer..
Thanks Manish, for your support.