topic Transform Line to colum in QlikView

Transform Line to colum

Judicael — Sat, 16 Nov 2024 20:12:22 GMT

Hello,

How can I tranform tab Data to Tab RESULT in (Excel File) automatically mode with for next if it is necessary.

Data in attachment.

Thanks for your help,

Regards,

Re: Transform Line to colum

Judicael — Fri, 23 Aug 2019 16:24:52 GMT

Re: Transform Line to colum

dplr-rn — Fri, 23 Aug 2019 16:34:41 GMT

Am i right in guessing you want all the rows to be split with '[Actif]'

Use something like below while loading the data

load *
where PROFILES <>''
;
load id,
SubField(trim(PROFILES),' [Actif]')as PROFILES
;
LOAD id,
PROFILES
FROM
[C:\Users\Downloads\Data.xls]
(biff, embedded labels, table is Data$);

result

Re: Transform Line to colum

Judicael — Fri, 23 Aug 2019 21:31:05 GMT

Thanks you very much!!