Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 3 csv files in a location sales1.csv, sales2.csv, sales3.csv I am using For each loop next to load all files. but it is failing to load the last file because the header line is different from the first 2 " (txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is 2 line) " vs (txt, codepage is 28591, embedded labels, delimiter is ',', msq) for the first 2.
how can I take care of the issue since in cannot modified the last file Sales3.csv
For Each vFiles in Filelist ('$(Filepath)/*.csv')
Sales:
Load
*
From $(vFiles)
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
Next vFiles ;
For Each vFiles in Filelist ('$(Filepath)/*.csv')
Let vHeader = if('$(vFiles)' like '*sales3.csv', 2, 0);
Sales:
Load
*
From $(vFiles)
(txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is $(vHeader) line);
Next vFiles ;
-Rob
For Each vFile in FileList('$(FilePath)/*.csv')
// Check if the file name is 'sales3.csv'
If vFile = 'sales3.csv' Then
Load
*
From [$(vFile)]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is 2 lines);
Else
Load
*
From [$(vFile)]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
End If
Next vFile
For Each vFiles in Filelist ('$(Filepath)/*.csv')
Let vHeader = if('$(vFiles)' like '*sales3.csv', 2, 0);
Sales:
Load
*
From $(vFiles)
(txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is $(vHeader) line);
Next vFiles ;
-Rob
For Each vFile in FileList('$(FilePath)/*.csv')
// Check if the file name is 'sales3.csv'
If vFile = 'sales3.csv' Then
Load
*
From [$(vFile)]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq, header is 2 lines);
Else
Load
*
From [$(vFile)]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
End If
Next vFile