Convert Rows to Columns for relationship

[Yevhenii_Senko]

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.

[venkatg6759]

Hi ,

Look for Generic Load option .

The Generic Load

[krishna_2644]

Something like this?

PSA.

Hope that helps.

[MarcoWedel]

can you elaborate on those relations a bit?

[Yevhenii_Senko]

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.

[MarcoWedel]

Hi,

I guess krishna_2644 crosstable solution does exactly that.

regards

Marco

[vardhancse]

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