Using excel column in sql where clause

[emyemyemy]

I want to use the quantity column  from my excel table  in the  sql where clause !

this is the code that i tried  but it didn't work  : 

LOAD   product,Quantity
FROM
[MyFile]
(ooxml, embedded labels, table is Sheet) ;

right join

SQL
select  product
from `DB`.`table` where 
(Quantity - count(product)) <=0 group by  product ;

Thanks for any help and attention !

[MayilVahanan · Accepted solution]

Hi @emyemyemy 

One of the way to achieve based on ApplyMap concept like below. 

MapQuantity:

Mapping Load product,Quantity
FROM
[MyFile]
(ooxml, embedded labels, table is Sheet) ;

Load *, where ApplyMap('MapQuantity', product, 0) - ProdCount <= 0;
select  product, count(product) as ProdCount
from `DB`.`table` group by  product ;

Hope it helps

[emyemyemy]

You made my day ,  I have  never woked  with  mapping , I will learn about it more !

Thank you for help !

[emyemyemy]

Hi  mayilvahanan !

Can you  check my problem here I will be greatful !

https://community.qlik.com/t5/QlikView-App-Development/Get-Excel-column-list-that-it-s-value-doesn-t...