calculated column from current data table is not showing in the insert columns window to match with second data table.

[Manideep HV]

Dear Community,

I have a data table with huge number of columns and I have a calculated column in the same table.

I am planning to join this table with another table using the calculated column as matching column.

I cannot see this column in the insert columns wizard.

Any inputs would be appreciated.

Thanks in advanced.

[Aditya Singh 3]

Calculated columns are not shown in the Insert Columns/Rows since they are part of extra columns and not imported from source. If you need to match column then you have to create calculated column at the "Transformations" level. This way if you create calculated column then its considered as Imported column and can be used for matching columns.

[John Wahrenberger]

having to transform a column seems to be a work around for much needed funcationality that should already exist. What if you create 4, 5, or 6 calculated columns in order to create the final column you are planning to use to relate transform all your data away There has got to be a better solution.