topic Convert Rows to Columns for relationship in QlikView

Convert Rows to Columns for relationship

Yevhenii_Senko — Thu, 10 Nov 2016 19:18:19 GMT

Hi,

Below are two tables.

Table1

Table2

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

Grateful for any solution.

venkatg6759 — Thu, 10 Nov 2016 19:35:13 GMT

Hi ,

Look for Generic Load option .

Qrishna — Thu, 10 Nov 2016 23:28:21 GMT

Something like this?

PSA.

Hope that helps.

MarcoWedel — Fri, 11 Nov 2016 00:24:14 GMT

can you elaborate on those relations a bit?

Yevhenii_Senko — Sun, 13 Nov 2016 16:05:09 GMT

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 — Sun, 13 Nov 2016 21:51:49 GMT

Hi,

I guess krishna_2644 crosstable solution does exactly that.

regards

Marco

vardhancse — Mon, 14 Nov 2016 03:25:57 GMT

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