Calculate maximum field length

Hi,

sometimes it’s useful to know maximum field length of string fields inside of a database table or an data stream.
Is there a trick or a hint to get maximum length of content of a data stream? For one string field - easy job. But if you don’t know data source and there are many string fields it could be very useful…

Would be great to get some help…

Stephan

Hi Stephan, Happy new Year!

I attached you a workflow with 3 possible solution.

  1. generate one column containing all strings,
  2. use a column list loop
  3. some coding with the column expression node.

Cheers, Iris

PS: I guess we will meet at the Spring Summit2018_01_04_LengthofAllString.knwf (30.9 KB)

3 Likes