Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional value on load

IDAccountSLANo SLA
1Personal15
2Home 12
3Fire 2
4Sys 10
IDAccountType
1Personal12
2Home3
3Sys 4
4Place2

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

1 Reply
Not applicable
Author

untitled.bmp

Sorry look like the above