Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert a single row to a column in qlikview with out generic load?
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
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
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
Using subfield() function may help you!