Fieldvalue conversion

[rahulsud007]

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?

[MK_QSL]

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;

[rahulsud007]

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

[maxgro]

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;

[rahulsud007]

Hi Massimo, its not working as required. If u are getting it appropriately as I mentioned please share the Qvw.

[#6]

Hi Rahul S,

As Massimo said it works just fine. I tried it on my machine.

[maxgro]

PFA

[rahulsud007]

Hi Massimo,

It worked, thanks a lot.

[MK_QSL]

When I worked on your question, i used IterNo() as id while iteration.. but by mistake has removed while uploading answer..

[rahulsud007]

Thanks Manish, for your support.