How to convert a column into ('(value1)','(value2)',..)

[atsushi_saijo]

Dear Gurus,

Would you possibly advise how to convert values in a column into the form ('(value1)','(value2)',......)?

Let's say there is unique values in a single column table;

Unique
a
b
c
d
e

I would like to create something like

SET vCOND=('a','b','c','d','e');

I would highly appreciarte for your input.

Atsushi

[atsushi_saijo]

Sorry maybe I should have used EXIST()

I will close this thread.

[ashfaq_haseeb]

Hi,

You didn't mark any answer as correct

Regards

ASHFAQ

[atsushi_saijo]

Hi, I have had an issue to pass this value to MATCH(field, $(vCOND)) and I did not marked. It does display on the UI. Would you possibly advise why it cannot work in this? (or maybe my experiment was not correct?) I'd appreciate for any feedback. Atsushi

[anbu1984]

Match should work. Can you post your app.

[atsushi_saijo]

Good morning, and I apologize for taking time. I attempted to inherit $() variables during script, but it did not succeeded. Besides, other developers has encountered same issue. Referred solution of CONCAT is only workable in the UI area (charts etc) but not within the script.

The solution in this specific case was to use in MATCH() during loading. The resolution was to use EXIST() in a condition close for a field.

TBL: LOAD

          IF( EXISTS(Unique,A), 1) as _ID

          RESIDENT .....

Atsushi