| ID | Account | SLA | No SLA | |
| 1 | Personal | 15 | | |
| 2 | Home | | 12 | |
| 3 | Fire | | 2 | |
| 4 | Sys | | 10 | |
| | | | | |
| | | | | |
| ID | Account | Type | | |
| 1 | Personal | 12 | | |
| 2 | Home | 3 | | |
| 3 | Sys | | 4 | |
| 4 | Place | 2 | | |
Hi Experts
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
Thanks
A
