How to convert a single row to a column in qlikview with out generic load?

[#1]

How to convert a single row to a column in qlikview with out generic load?

[Anonymous]

Hi

if you row is having some delimiters like      ,  or     ;

the following will help you .

thanks to sunny

ETL Script - how split data separate with ';'

: or

"https://community.qlik.com/thread/223949"

[#3]

Hi Srikanth,

If you want to convert a row into a column, may be you can achieve this say for example:

INPUT is

Item no          Dimension   Dimension Value

FDABT001     BRAND        ABZ Group  

FDABT001     DEPT           Domestic Marketing

OUTPUT is

ITem no         BRAND       Dept                         THERSEG

=============================================

FDABT001     abz group   Domestic Marketing    Anti-Helmintic

You can achieve this as separate table, as follows :

Table1:

Load

Item no,

Dimension value as BRAND

from Table1 where Dimension = 'BRAND'

JOIN

Table2:

Load

Item no,

Dimension value as DEPT

from Table2 where Dimension = 'DEPT'

and so on....

Hope it helps you

Thanks

[Anonymous]

Hi,

You can either use a pivot table and adjust the row: https://community.qlikview.com/thread/35986

Or

you an use the crosstable function: CROSSTABLE Vs CrossTab in script and The Crosstable Load

[#5]

Using subfield() function may help you!