Suggest an Idea

[Vegar]

FieldValueList is an useful feature in the for each ... next loop, but it would also be quite useful in the rest of the script. 

Today we can accomplish the same as an FieldValueList function would do by the following script.

FieldValues:
LOAD Concat(Chr(39) & [Field] & Chr(39), ',') as FieldValueList;
LOAD Field FROM SOURCE;
LET vFieldValueList = Peek('FieldValueList',-1,FieldValues);
DROP TABLE FieldValues

It would be easier and more available for all developers if the same output would be available from this command.

LET vFieldValueList = FieldValueList('Field');

As it is available in the for each ... next loop I would guess that it could not big a deal to open up for using it in the rest of the script

[Patric_Nordstrom]

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.