Forum Discussion
Solved
Evaluate text field value and create a column based on unique occurrences
Hello everyone, I have a huge data center usage dataset that contains a colum "EquipmentId". The Equipment ID colulmn contains alpha numerical values. In a million plus rows, there are a couple of...
Go to 'Transform Data'
Select the table with all of your data and then select 'Merge Queries'
Select the mapping table and then select the 'EquipmentId' column for both tables...
After clicking 'OK' you will have a new column added to your table that has a table in each row.Expand that column. Select only the Department and deselect the 'Use original column name...'
After clicking OK you should have the desired result in your table...
