This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@rafalolbert has great suggestion but you need to watch for any characters other than digits in the input. The Cross Tab tool is very picky about what it considers a valid characrter in a field name and converts all the others to underscores. I added a couple of values, -4, 7.1 and -3.1 to the input to illustrate. the result is as follows
The -4 becomes "_4", -3.1 becomes "_3_1" and 7.1 becomes "7_1". You can add a Dynamic Rename to fix these by replacing the "_" with "-"(minus) if its the first character and replace it with "." period otherwise. The cross tab also reorders the columns alphabetically. In the input list the -3.1 was added after the 7.1, but in the crosstabbed fields it is before. This can be a problem if you need to have values displayed in the original order. Using this technique with alpha-numeric data almost always guarantees that the list will be sorted in the incorrect order
Of course, you can avoid all these issues by writing to a external source and having the list input read from it, even though this is a route you would rather not take. BTW: .yxdb is the fastest format to use should you reconsider
The other thing to remember is that the list will not be dynamic. The example shown will work, however that list then won't change as the interface tools are configured by the front end before the engine runs any of the normal tools.