Hi, I have a problem in my tables viewer; so in my script.
This is my tables:
FOR each vFile in filelist('$(vCheminData)FILE.DAT')
TMP_WORKFLOW: LOAD text([Division] & '-' & [Num]) AS %NumComplet, [step Code] AS [Code Step], [Service Code] AS %CodeService FROM $(vFile) (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);
STORE D_WORKFLOW INTO '$(vCheminQVD)D_WF.qvd' (QVD); DROP TABLE TMP_WORKFLOW; NEXT vFile
TMP_SERVICE: LOAD [Code Service] AS %CodeService, [Name Service], [Code Service] & ' - ' & [Name Service] AS Service FROM $(vFile) (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes); // (.DAT)
The Tmp tables are for the modifications and the normal tables are for the finised tables. I'm trying to separate the table Service, who is usually in the workflow table; because it's a key, i need to reduce to the maximum the main table so WORKFLOW and have all secondary tables with the same kind of informations, so here: the service code, the service name, and the service (code + name). So i have to separate it like this ... If I don't use the