Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi @GOKULAKANNAN ,
I hope that solves your query.