Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GOKULAKANNAN
Creator
Creator

how to fetch value with comma seperated

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.

2 Solutions

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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 :

AshutoshBhumkar_0-1635272360565.png

 

Thanks,

Ashutosh

View solution in original post

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi @GOKULAKANNAN ,

I hope that solves your query.

View solution in original post

2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

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 :

AshutoshBhumkar_0-1635272360565.png

 

Thanks,

Ashutosh

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi @GOKULAKANNAN ,

I hope that solves your query.