Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have a two columns
Date Platform
10/1/2014 STAR
11/1/2014 STAR
When i concatenate both Columns and Load its displayed as
41913STAR
But my expected output should be as MM/DD/YYYYSTAR
Use =Date(yourfield,'MM/DD/YYYY')
Hi,
Try like this
Load *,Date(Date,'MM/DD/YYYY')&Platform as Key;
LOAD * INLINE [
Date,Platform
10/1/2014,STAR
11/1/2014,STAR
];
load date(date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') &Platform as key inline
[
Date, Platform
10/1/2014, STAR
11/1/2014, STAR
];
Try like
LOAD *, Date#(Date, 'DD/M/YYYY')&Platform as Key
Inline [
Date, Platform
10/1/2014, STAR
11/1/2014, STAR
];