Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to everybody!
I am new in Qlik Sense and I have a question, I hope you can help me.
Right now I have a table named Product. In the Product table I have an attribute named Stock. This stock is going to be updated everyday and it has to options. The value of the stock can be Yes or Not. My goal is to create a new attribute in the table Product where if the value of stock is Yes the value of the new attribute is 1 and 0 if the value of stock is Not.
Is it possible to create that new attribute from the table itself? If so, how can I create that new attribute?
Thank you very much in advanced!
Maybe i am misunderstanding some underlying complexity.
but typical way to do this is like below
load attr1,
. //Other columns/attributes
,
Stock,
if(Stock = 'Yes',1,0) as StockFlag
;
sql
load * from ProductTable;
Maybe i am misunderstanding some underlying complexity.
but typical way to do this is like below
load attr1,
. //Other columns/attributes
,
Stock,
if(Stock = 'Yes',1,0) as StockFlag
;
sql
load * from ProductTable;
Thank you very much, problem solved!
Mark the answer as solution please