Discussion board where members can get started with QlikView.
I want to know that how to deal with this type of data attached below in the CSV format. If we have different type of date format in the data source, then how to make it look in a single format?
I know below code is not right, but help me people to correct this one.
This is my code:
What format does the Date field in your CSV file have at the moment? Or actually what formats, since you mention multiple formats. Can you give an example of each?
Also, how would you like the values to be formatted in QlikView?
There are mixed values
Numerical format: 01/01/2012
Text format: 01-Jan-2012, 01-01-2012, 01/Jan/2012
in the field "date"
& I want it all of them in a single common format, either it would be in text or inumerical.
Alt( Timestamp#(MixDate,'M/D/YYYY h:mm tt'),
) as MixDate