Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load text without "Headers"

Hi guys!

I'm trying to load data to table on "Edit Script", but don't know how should i treat my data.

My load data is like (text), with NO headers name and with ";" as diference caracter:

8434108097693;61CM20030015100;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

8434108097709;61CM20030015102;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

8434108097716;61CM20030015104;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;

I would want to create table (in load) and create headers, like:

COD1 | COD2 | TYPE | DETAIL | DETAIL2 | SIZE | DATA |

8434108097693;61CM20030015100;shirt;CAMISA;CLÁSICA;M;00-02-04-06-08-10-12;


is it possible ?

Have any one some ideia ?


Article:

LOAD
     (probably create some "for" cicle for each line, and write for each line)

FROM E:\..\Data-*.txt (txt, codepage is 1252, embedded labels, delimiter is ';', msq);


Best regards,

VL

1 Solution

Accepted Solutions
Not applicable
Author

Thanks for "Allow".

I solve it, already!

Article:

  LOAD

      @1 As COD1 ,

      @2 as COD2 ,

      @3 as TYPE ,

      ....

  From E:\..\Data-*.txt

  (txt, codepage is 1252, no labels, delimiter is ';', msq);

Thanks!
VL

View solution in original post

1 Reply
Not applicable
Author

Thanks for "Allow".

I solve it, already!

Article:

  LOAD

      @1 As COD1 ,

      @2 as COD2 ,

      @3 as TYPE ,

      ....

  From E:\..\Data-*.txt

  (txt, codepage is 1252, no labels, delimiter is ';', msq);

Thanks!
VL