Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write logic for looping through columns in table for the particular row.
Can we use numbers to recognise the columns or is there any other way to iterate through columns?
Thanks In Advance.
In Table 1 , Richard has 1 as value for A1 and A4. and because of that it's reflecting twice in tab2 table. My requirement is in tab 2, I only need one row for each user ( any random out of two ) .
Table 1:
Name | A1 | A2 | A3 | A4 |
Sam | 1 |
|
|
|
Linda |
|
| 1 |
|
Richard | 1 |
|
| 1 |
Sandy |
| 1 |
|
|
Ben |
|
|
| 1 |
Tom |
|
|
| 1 |
lookup table :-
Code | Area |
A1 | ABC |
A2 | XYZ |
A3 | ABC |
A4 | EFG |
Tab 2:
Name | Code | Value |
Sam | ABC | 1 |
Linda | ABC | 1 |
Richard | ABC | 1 |
Richard | EFG | 1 |
Sandy | XYZ | 1 |
Ben | EFG | 1 |
Tom | EFG | 1 |