Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, My input field is the following and
Input | |
ID | Month |
Ak | 10101 |
AJ | 11111 |
I need output in following way. in
ID | Month |
AK | 1 |
AK | 0 |
AK | 1 |
AK | 0 |
AK | 1 |
AJ | 1 |
aj | 1 |
aj | 1 |
aj | 1 |
aj | 1 |
Can anyone help me in this?
T1:
Load *, Len(Month) as Length Inline
[
D, Month
AK, 10101
AJ, 11111
];
T2:
Load
D,
Mid(Month,IterNo(),1) as Month
Resident T1
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
AK 0
AK 1
Ak 0
AK 1
AJ 1
AJ 1
AJ 1
AJ 1
add an id in load, you can use it in straight table chart and hide
T2:
Load
rowno() as id,
D,
Mid(Month,IterNo(),1) as Month
Resident T1
While IterNo() <= Length;
Drop table T1;
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.
PFA
Hi Massimo,
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.