Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sk0
Contributor
Contributor

tAggregateRow

Hai,

1. I have a input file 

c1,c2,c3,c4,c5

1,x,x,x,x

x,1,x,x,x

x,x,1,x,x

x,x,x,1,x

but i need a output as "1,1,1,1,x"

Thank you.

 

 

Labels (2)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

Solution 1)
Tsortrow . Your output would be 1st or last last row

Solution 2) min/max in taggregaterow

View solution in original post

5 Replies
akumar2301
Specialist II
Specialist II

Solution 1)
Tsortrow . Your output would be 1st or last last row

Solution 2) min/max in taggregaterow
sk0
Contributor
Contributor
Author

I Cant able to do it .
could you please explain me clearly.
Thank you.
akumar2301
Specialist II
Specialist II

0683p000009M4ke.jpg

sk0
Contributor
Contributor
Author

Thank you for the help will be in touch 

dilip_n
Contributor II
Contributor II

0695b00000dcgEbAAI.png