How to use between for Alphanumeric Values in if condition.

[renuka_sasikumar]

Hello,

I have to build a logic in script end where I have to calculate value on the basis of some filtration.

for e.g.: I have a field named Value, and to check is Record Type = F and Item in (ZABC,ZABD,ZALB, ZANC to ZAX2).

So how should I go about it, I tried by doing this which is not correct, I will have problem in future if there is any new ITEM added in Master. 

IF(REC_TYPE=F AND (MATCH(ITEM,ZABC,ZABD,ZALB, ZANC,ZAP1,ZALN,ZAX2)),VALUE)  as Value1

Can anyone help me with the solution which doesn't required manual entry in future.

Regards,

Renuka Sasikumar

[anushree1]

Hi Renuka,

Could you please elaborate along with a sample attachment.

It does 'nt seem to be very clear

[renuka_sasikumar]

Attached the App.

[anushree1]

Hi Renuka,

I am not sure if I got the requirement right to make things easy i put a inline table which states what are the essential Items you would want to filter and have only those loaded to the Fact so that if the list of essential filters change you can update the Item_check Inline Table and get the required rows.

Hope this helps, if not please explain what you have been actually looking for.

Please check the attachment  

[renuka_sasikumar]

Thank You, But this is not what I required. U are defining it as what u required in Item, But there maybe such Item which we don't know but it appears in between ZANC to ZAX2 (Item comes from Master Table).

Plus this is not the only logic which I have to apply, same like I have around 20-30. Currently I am hard coding it using IF condition.

Hope you got what I required it.

[renuka_sasikumar]

Anyone have any work around for this.

It will be helpful.