Need to use extracted MONTH from a date column along with two other columns to create a primary key

[mortensenpb]

I am trying to create a primary key column from the following data set I am importing from a text file.

Location	Prod_CD	Month	Qty
BLDV	11029	25569	2120.47
BLDV	11030	25569	15186.25
BLDV	11036	25569	3358.22
BLDV	11043	25569	1434.15
BLDV	11127	25569	1916.13

[Month] is a serial number corresponding to a date in 1970 but that is irrelevant to me so I have an import step that extracts just the month from from [Month] (the value is 8).

I want to use the combination of [Prod_CD], [Location], and Extract of [Month] to create a primary key.  I created a custom column with the following formula:

[Prod_CD]&[Location]&[Month]

This produces an error for the entire column.  The result I am looking to get is (for the first row) "12029BLDV8".

[ankitpatira]

@mortensenpb what error did you get when you created custom column ? make sure column is of type Text.

[mortensenpb · Accepted solution]

Adding another step transforming the extracted month into text fixed the issue.