I get loads of files in the above format dropped onto my drive into a specific folder , I then load them all to QV using the following code
let path_Alles = 'S:\Business Support\Business Support\Weekly to Monthly\Test\*.xls'; for each File in filelist (path_Alles)
concatenate LOAD *, If(exists(Activity_Description),'SUS','RDY')as Status, Filename() as File2
FROM [S;\Business Support\Business Support\Weekly to Monthly\Test\*.xls] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq, header is 2 lines, filters( Remove(Row, Pos(Top, 6)), Remove(Row, Pos(Top, 7)), Remove(Row, Pos(Top,8));
What I need is a Status colum that identifying if the data is from the top half of the report if so value=RDY , or the bottom half then value = SUS .
The above does not work as only the First sheet loaded has the first instance - so every sheet there after is SUS, also tried to do it based on rowno() - but same issue - an anyone advise
