Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Yevhenii_Senko
Contributor III
Contributor III

Convert Rows to Columns for relationship

Hi,

Below are two tables.

Table1

  

HorizontNameRowNameColumnName
1Name11Column1
1Name12Column2
1Name13Column3
1Name14Column4
2Name21Column5
2Name22Column6
2Name23Column7
2Name24Column8
3Name31Column9
3Name32Column10
3Name33Column11
3Name34Column12

  Table2 

Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column12
777777777777777777777777
444444444444444444444444

I need convert rows from Table1 to columns and make relationship between two tables.

Grateful for any solution.

6 Replies
venkatg6759
Creator III
Creator III

Hi ,

Look for Generic Load option .

The Generic Load

krishna_2644
Specialist III
Specialist III

Something like this?

1.PNG

PSA.

Hope that helps.

MarcoWedel

can you elaborate on those relations a bit?

Yevhenii_Senko
Contributor III
Contributor III
Author

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
Specialist III
Specialist III

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