i wish to make Product Group and ProductGroup1 into the same column. the key here is Item.
is there any way to do this.
i have mapped the values from another table based on Cost center. The original field Product Group comes from file upload into the FACT Table that is open on the sceen.
Concatenate both fields and give alias for single column.
Ex : Field1 & '|' & Field2 as NEW_FIELD
Retrieving data ...