Creating Custom Bins in Number Format

Solved4.36K viewsFormulas and Functions
0

I want to create Custom Bins to re-label the Date column imported from an Excel csv file for sorting. The Date is imported in the format mm/dd/yyyy and I want to reformat Date to only mm.

I accomplished this on importing the Date as an Integer. Then I want to create Custom Bins for each month converting the mm integer format to the text format. Ex. Custom Bin would be set to label the number 4 as Apr.

I add a column for Custom Bins and set up the bins but and when I click OK it works. However, as soon as I click anything else, all the Custom Bin labels revert to the default ‘Other’. It will not save.

Can anyone please tell me what I am doing wrong?? Attached is the Excel and model files. Thanks.

S A U Changed status to publish August 8, 2018
0

Hi TNicolle,
IMHO, your problem is solving by means of Custom format for the Date Item with ‘mmm’ date format string (see Data Table).
BUT, if the use of a bins is the strict requirement, see 2D Data Matrix::BinType group. It have two types of bins.
N.B. In CVS files for importing of dates QM strict likes such date format string: YYYY-MM-DD.

S A U Edited answer August 8, 2018

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes