setup the table as you have suggested and started the job it imported all the files within the first folder and deleted them as planned and it threw up this error...
if i now try to start the job again its says..
Thank you yes that worked, so now for a different question, i also have to import other text files they are in a folder and has then a folder for each day, folders are named as the date like this 2024-01-31 and contain 2-3 files in each folder how's best to get these to import in bulk too ?
I am trying to get this working i have a pivot that is showing at the moment three month columns.
I want to count the number of rows within the pivot that have data which is a number
=COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals)
=COUNTIF(R10:R150000, "<>")-1...
how do i copy this formula to all rows
=COUNTIF(A:A,A112911)
if i drag it it changed the row number
=COUNTIF(A:A,A112912)
=COUNTIF(A:A,A112913)
=COUNTIF(A:A,A112914)
=COUNTIF(A:A,A112915)
and so on..
Thanks all so i have now imported the file and have set the specification imported a test file and looks good so thanks got it sorted now for the formatting :)
So i need to break up a report that is provided in a continued string of data..
A1215455545444444842121212121212121TTTRTR2TR2TY2212121212212122121
The data will need to be broken out as following..
Record type
String
1
Always "A"
Supplier ID
Numeric
5
XXX01 where XXX is the 3-digit...