Remove $1 from resultset

Analytics
1

Hi,

How do I eliminate the $1 from the resultset? Here is my syntax:

(
         SELECT {'effDateFrom': MILLIS_TO_TZ(v.effDateFrom, 'Asia/Manila', '1111-11-11'), 'effDateTo': MILLIS_TO_TZ(v.effDateTo, 'Asia/Manila', '1111-11-11'), 'itemPrice': v.itemPrice}
         FROM r.itemPriceList AS v) AS itemPrice

image

2

Use VALUE. For example:

(
         SELECT VALUE {'effDateFrom': MILLIS_TO_TZ(v.effDateFrom, 'Asia/Manila', '1111-11-11'), 'effDateTo': MILLIS_TO_TZ(v.effDateTo, 'Asia/Manila', '1111-11-11'), 'itemPrice': v.itemPrice}
         FROM r.itemPriceList AS v) AS itemPrice
3

Thank you, @ali.alsuliman. It worked.