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?
Load ID,Mid(Month,IterNo(),1) As Month While IterNo() <= Len(Month);
Load * Inline [
ID,Month
Ak,10101
AJ,11111 ];
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??
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
same question, already answered