Multiple Values in Input Field

[shannoypaul]

Hi all,

If I am using an input field, any method to do a bulk load of values other than manually keying in the values.

TIA.

[PrashantSangle]

Not clearly understood , Can you explain in details??

Regards,

[rahulpawarb]

Hello Shannoy,

If you want to assign a list of values to a input filed then follow below approach:

- Create a variable in script and assign a list of values to it separated by comma

//Manual Approach

SET vMulti = 'Alpha, Bravo, Charlie, Delta';

//Dynamic Approach

Test:

LOAD * INLINE [

Name,Amount

Alpha,10

Bravo,20

Kilo,10

Lima,18

Mike,35

];

TempConcat:

LOAD Concat(Name,', ') as TempName

Resident Test

Where Amount  < 20;

Let vMulti = FieldValue('TempName',1);

Drop Table TempConcat;

Hope this will help.

Regards!

Rahul Pawar