Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry look like the above