conditional value on load

Thu, 01 Aug 2013 10:26:26 GMT

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

Re: conditional value on load

Thu, 01 Aug 2013 10:28:49 GMT

Sorry look like the above

topic conditional value on load in QlikView

conditional value on load

Re: conditional value on load