Jump to content
We've recently updated our Privacy Statement, available here. ×

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

Manideep HV

Recommended Posts

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.

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...