Value 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?

[anbu1984]

Load ID,Mid(Month,IterNo(),1) As Month While IterNo() <= Len(Month);

Load * Inline [

ID,Month

Ak,10101

AJ,11111 ];

[#3]

Hi Anbu,

I was just browsing through the community and found out this thread. I must say the soln. proposed by you is a good way to approach it. But if i display those values in a table box it is not showing the desired output. But the actual output is shown in Table viewer preview option. What is it i am doing wrong??

[its_anandrjs]

Hi Sashi,

Try to load like this way i am extending anbu script and for viewing the values add Recno() function for check the values.

Temp1:

Load ID,Mid(Month,IterNo(),1) As Month While IterNo() <= Len(Month);

Load * Inline [

ID,Month

Ak,10101

AJ,11111 ];

LOAD

*,

RecNo() as Key

Resident Temp1;

DROP Table Temp1;

Check the attached also

Regards

Anand

[maxgro]

same question, already answered

Fieldvalue conversion