Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
let's say I have a table like this
F1
A
B
C
need a expression in text box to show this result
'A','B','C'
how to do this ? thanks
it says expression error in my side , have you tried ?
Checking
Yes, you are right, for some reason it doesn't work.... I guess you can remove the space using PurgeChar or replace, but why would you want to do that when you have easier solutions, right?
=PurgeChar(Concat(DISTINCT ' '' ' & F1 & ' '' ', ', '), ' ')
Hello everyone,
I'm facing a similar issue to what was previously discussed, and I've tried the solution suggested, but it hasn't worked for me. My goal is to save a column of data into an array using the Peek function with the structure above, but I'm having trouble with it. Can someone please help me out?
Post sample data and desired results.
This Sample should be okay, I guess:
I have a table like below.
Name of Customer
Customer1
Customer2
Customer3
......
I would like to create a variable called 'vCustomers' that will contain the following values: 'Customer1', 'Customer2', 'Customer3', and so on. The reason for creating this variable is to use it in a SQL query.
SELECT * FROM (Table in Data Lake) WHERE Name IN (vCustomers);
This expression Concat(DISTINCT Chr(39) & NAME & Chr(39), ', ') will work for you.
please accept the solution if u liked it.
I tried your solution, but I received an empty variable. I am unsure why it did not work.