Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Expert,
Loading data from one file and want to generate multiple field against same field, the result value set is OK but the duplications values appear in list. For example:
Date | Sales |
---|---|
2012/12/05 | 500 |
2012/12/06 | 600 |
2012/12/07 | 700 |
2012/12/08 | 800 |
Load command as
LOAD Date,
Date(Date, 'YYYY') as Year,
Date(Date, 'WWWW') as Day,
Sales
FROM File.
Result
Date | Year | Day | Sales |
---|---|---|---|
2012/12/05 | 2012 | Wed | 500 |
2012/12/06 | 2012 | Thur | 600 |
2012/12/07 | 2012 | Fri | 700 |
2012/12/08 | 2012 | Sat | 800 |
In Fields Displayed in Listboxs select all.
The expected Listbox value for 'Year' is only one value '2012'. However, the actual is 4 single value(2012) in the list box. Apparently the year is sticking to original value set. Is there any way to break the link?
Many thanks!
HTC
Try Year(Date) and Weekday(Date) - if memory serves, Date() will just reformat the date but maintain the original value.
Try Year(Date) and Weekday(Date) - if memory serves, Date() will just reformat the date but maintain the original value.