Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
can you explain with sample data ??
and required output..
the output is the concatenated field ,
sample data is as above
can plz help as its a bit urgent requirement
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;
this is giving me concatenated fields all in single row when taking a list box,
kindly help what to do