how to fetch value with comma seperated

[GOKULAKANNAN]

Hi,

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

table1:

date	financial year	financial week	financial month
23/07/2021	2021	35	7
24/08/2021	2021	39	8

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 · Accepted solution]

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 · Accepted solution]

Hi @GOKULAKANNAN ,

I hope that solves your query.