Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Reading field values from a file

Hi All,

I have an excel which has values in column1 as

Column1

A

B

C

I want to store the values of Column1 in a csv file.

The values should be stored as

A,B,C

Is it possible?

Thanks,

Asma

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Reading field values from a file

Yes possible

T1:

Load Concat(Column1,',') As Column1 From Excel.xlsx;

Store T1 into T1.csv(Txt);

1 Reply
anbu1984
Honored Contributor III

Re: Reading field values from a file

Yes possible

T1:

Load Concat(Column1,',') As Column1 From Excel.xlsx;

Store T1 into T1.csv(Txt);

Community Browser