Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

4 Replies
Anonymous
Not applicable
Author

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"

Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

Using subfield() function may help you!