Hi,
I want to know the easiest way to get the value of a DB result Set(on column only) to a string with commas.
For Eg.
If I have a DB Result as
Column_Name
A
B
C
D
I want to have a filter, say, {{flt01}} with value "A,B,C,".
Please help.
Thanks in advance.
Bibin,
The easiest way might be to let your DB server generate it for you as described in article . Please note that the result can be rely large string if you have large table.
Let me know if for some reason this approach does not work for you.
Regards,
Arif
I liked the approach. But to be frank, I did not understand the code. Can you please explain the code and help me write a similar in LISA javascript step? Thanks.
Also, what if my db result is a matrix say
col1 col2 col3
a b c
dd ss se
There are two ways, 1 if you want to eventually write to a flat file, there is a step Write To Delimited File or use a parse text step with {{col1}},{{col2
}},{{col3}} to create 1 long string of the values.
To be DB agnostic I created attached sample that uses xml xpath filters to get one column values separated by new line and then used javascript operator to replace new lines with comma.
Thanks a lot Arif_Muhammad...I was looking for this solution only. Thanks again.
But, I have heard that using XML XPath filter is not good when handling large amount of data. In my case, it's hardly few rows/column combination. But is there any way to handle large result set in LISA without XPath filter?
Any help will be appreciated.
Thanks.
Bibin,
If you have large DB to convert the best performance can be achieved by having the DB query in a way that DB Server sends the data in desired form back. The only issue is that there is no standard for what you are trying to do here so you will have to use the DB specific capabilities. May be to make it little more DB agnostic you can encapsulate the processing into an Stored procedure and use the SP. What DB server are you working with?
To be DB agnostic I created attached sample that uses xml xpath filters to get one column values separated by new line and then used javascript operator to replace new lines with comma.