Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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