How to join UD table on Sysrow and Part

im trying to bring in UD_Part to this database and have it as a property of the PartNum but its trying to join on Partnum and not sysrowID. i need to join E&O.SysrowID on UD_Part.ForeignSysrowID.
how can i do that?

Hi @Crogers,

I believe it’s asking you to map to PartNum because your PartNum Dimension is probably mapped from that type of column in your transaction data. So now it’s asking you to map something as a key-value to match up to the transaction data.

That being said, you would need to change which column is mapped from the transaction data to that PartNum Dimension. Then, it should ask you to match your new data key value to the column you have newly mapped as the dimension.


1 Like