Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below are two tables.
Table1
HorizontName | RowName | ColumnName |
1 | Name11 | Column1 |
1 | Name12 | Column2 |
1 | Name13 | Column3 |
1 | Name14 | Column4 |
2 | Name21 | Column5 |
2 | Name22 | Column6 |
2 | Name23 | Column7 |
2 | Name24 | Column8 |
3 | Name31 | Column9 |
3 | Name32 | Column10 |
3 | Name33 | Column11 |
3 | Name34 | Column12 |
Table2
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 |
77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 | 77 |
44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 |
I need convert rows from Table1 to columns and make relationship between two tables.
Grateful for any solution.
Something like this?
PSA.
Hope that helps.
can you elaborate on those relations a bit?
Hi,
The Generic Load is good decision.
But I don't need put data from "RowName" to values..
I want to use data from "RowName" as selectors.
For example create LIst Box and show all values from "RowName" there.
When I select "Name11" will get all data values from Column1 (77,44) according to relationship between these to tables by ColumnName.
Using cross table we can able to achieve
Below is the syntax for your reference:
Table:
CrossTable([New field Name],[Data for the field],[Field count how many need to be ignored])
LOAD
Field1,
Field2
From Table1;
**In general maintain the fields which we want to convert to Rows/columns in last while loading