Hi , i have scenario where i have few rows in my SQL DB in that few file names and PageTitle will be same. I need to filter it through file name and display them in horizontal gallery if any file name having 2 rows in DB in gallery also i need in 2 rows. I'm providing my sample input and output below.
Input data from DB
DocName PageNo PageTitle ItemName ItemValue
Image.pdf 3 Bill Quantity 3 00
Image.pdf 3 Bill Amount 500
Image.pdf 3 Bill Type Water
Image1.pdf 3 kret Quantity 8 00
Image1.pdf 3 Kret Amount 100
Image1.pdf 3 Kret Type null
Image.pdf 3 Bill Quantity 6 00
Image.pdf 3 Bill Amount 300
Image.pdf 3 Bill Type Oil
Output needed in horizontal gallery if i filter it through Docname:
Quantity Amount Type
3 00 500 Water
6 00 300 Oil
