I have an order list in csv file. I want to transform the data.
here's my query. I have to add 2 new columns "gift box set" and blue oyser mushroom". If name in V column contains gift box set, then show 1, otherwise leave it blank. Please help me to correct my query. also how can I give a new column name for those 2 added columns?
=query(orders!A2:AP134, "select Q, K, V, if(V="Gift Box Set 5lbs", "1", ""), if(V="Blue Oyster Mushroom 3lbs", "1", "")", true)

Aucun commentaire:
Enregistrer un commentaire