urgent requirement

[Anonymous]

i have  a requirement

where i have two dimensions say,

x and y

there are around141 combination conditions of the two fields for which i need to create a concatenated field,

like ,

x='value1' and y='value2'

x='value1' and y='value3'

x='value1' and y='value4'

like this i have 14 values in x dimension and 14 in y dimension so there has to be possible all combinations for both field values,

if i write with if statement in sciprt it will bearound 14*14=196 conditions,

how i shud achieve this?

[big_dreams]

can you explain with sample data ??

and required output..

[Anonymous]

the output is the concatenated field ,

sample data is as above

[Anonymous]

can  plz help as its a bit urgent requirement

[jonathandienst]

If you give a brief statement of your question as the title for your post, you are more likely to get useful help, than "Urgent Requirement". Anyway, this will put all the combinations into a variable. Adapt for your exact requirements:

T1:

LOAD x Resident Data;

Join(T1)

LOAD y Resident Data;

T2:

LOAD Concat('x=' & chr(39) x & chr(39) & ' and ' & chr(39) & y & chr(39), chr(10)) as Result

Resident T1;

Let vResult = Peek('Result');

DROP Table T1, T2;

[Anonymous]

this is giving me concatenated fields all in single row when taking a list box,

kindly help what to do