Combining 2 columns - showing error in Transform Data

[Anonymous]

hi all,

created a column when in Data view with Add Column as below:

CC Key = [COST_CATEGORY_ID]&[SUB_CATEGORY_ID]

its fine, but when go to Transforrm Data there it is showing Error... what i am mistaking here or something missing? please help.

below is screenshot ( actually 2 screenshots in 1 )

regards

[Anonymous · Accepted solution]

problem solved.

in Transform Data, removed the created column, selected 2 columns as required, and used Merge Columns and its done.