topic Re: how to fetch value with comma seperated in App Development

how to fetch value with comma seperated

GOKULAKANNAN — Tue, 26 Oct 2021 16:28:30 GMT

Hi,

I have a table with date fields, I need to fetch the week fields with comma separated .

table1:

I need output from the above table like below and I need to put it in a variable

let vWeek = financial week values with comma separated (35,39)

how to achieve this.

AshutoshBhumkar — Tue, 26 Oct 2021 18:19:31 GMT

Hello,

Check below example.

Table:
Load * Inline [
Date,Year,Week

23//07/2021,2021,35
24/08/2021,2021,39

];

Final:
Load
Concat(DISTINCT Week,',') AS WeekCommaSeparated

Resident Table;

Let vVariable = Peek('WeekCommaSeparated',0,'Final');

Exit Script;

Output :

Thanks,

Ashutosh

AshutoshBhumkar — Thu, 28 Oct 2021 04:34:12 GMT

I hope that solves your query.