Load script table manipulation?!?

[#1]

hoping someone can help...if this is even possible?!?

I have the following table...

number	YCH G	BWM G	BRN G	LWH G	KNI G	LNI G	MAC G	MCI G	VWM G
10602906-2	y	n	n	n	n	n	n	n	n
10605441	n	y	n	n	n	n	n	n	n
20118159	n	n	n	n	n	n	n	y	y
20743581	n	y	y	n	n	n	n	n	n

and what I want to do is create a secondary table as a lookup for my main table above.. i.e when I select number 20118159 I want to be able to select from a list any site code where there is a 'y' in the column... can I create a create a table like this...

number	site_code
10602906-2	YCH G
10605441	BWM G
20118159	MCI G
20118159	VWM G
20743581	BWM G
20743581	BRN G

so that I can have a list box of sites and my main table will reurn the related numbers?!?

Does that make any sense?

[qlikconsultant]

I'm not sure what you you want with isnull?

[#3]

when there is a 'y' or 'null' in the filed I want it flagged (i.e treating nulls as 'y')

[qlikconsultant]

Should look like

NoConcatenate LOAD * Resident CroTables where Flag = 'y' or IsNull(Flag)='-1'

[#5]

added that all i think i need to do now is add to the site_code lookup table (where description is held) is where site_code isnull then description is 'not entered' this lookup is coming from an excel sheet.

[#6]

Thanks so much for you help the other day.... I also need to pick up null values as well as 'y' , how can I include these?

[tresesco]

Try like:

Where Flag='y' or Len(Trim(Flag))=0 ;

[#8]

that doesnt seem to work

Is there any way I can get the 'nulls' to text as 'not entered' and display these in my location table?

[tresesco]

Try like:

NullAsValue YourField;

Set NullValue = 'Not entered';

[#10]

sorry not sure where to put this

[tresesco]

In the script before you start your scripting: