Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

Yes possible

T1:

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

Store T1 into T1.csv(Txt);

View solution in original post

1 Reply
anbu1984
Master III
Master III

Yes possible

T1:

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

Store T1 into T1.csv(Txt);