list
1 Topic
Retrieving the biggest text length value for every column in table
Hi! I'm cleaning and preparing data before an erp migration, and I would prefer to have the task more automated since the it will be recurring. I need to check every column for it's longest value (longest as in largest amount of characters) to ensure that the set length limitations in the target erp do not cut any values Let's say I have data that looks like this: Table.FromRecords({ [CustomerID = 1, Name = "Bob", Phone = "123-456712"], [CustomerID = 22, Name = "Jim", Phone = "987-6543"], [CustomerID = 333, Name = "Paul", Phone = "543-7890"], [CustomerID = 4444, Name = "Ringo", Phone = "232-155042424"] }) Here I would want a table with two colums, or any viable solution, really. One with the column names from the source data, and one with a number representing the longest value for that column. Also preferably not hard coded with column names or similar, to be able to swiftly reuse for new cases. Something like this: ColName - Len CustomerID - 4 Name - 5 Phone - 13 Hope you can crack this one!Solved2KViews0likes3Comments