Hello, I want to transpose below data into rows so that I can insert this into a gallery..
I want the data to be in this format.
KIndly help
Yes, but like I said...WIP is a table! That is why you are seeing what you are seeing.
You need to specify a record. Your First(colClientDetails).WIP is going to return a table (the WIP table).
If you are only concerned about the first record of that, then you need to specify: First(First(colClientDetails).WIP)
colClientDetails is a collection which holds client information. it has Parent child relationship.. Example one client can have multiple WIP values.. In the colClientDetails collection WIP is a table. that is why I have used first to fetch the records only for WIP using this First(colClientDetails.WIP).WIP.
That is because you are specifying a table as your source and not a record.
What is colClientDetails? And you only want the first record from it??
Yes I have switched it and now I get two columns out of which one is a table. Is this correct and how do I display the value column in the gallery using below data
Yes, you will get those results with that formula! You have it backward from what I sent.
You have the Name and Value switched. Please review the formula I provided for more detail.
HI @RandyHayes , thank you for the answer, I have applied your formula. but this is how I get the result.
the data is not proper still
It will all be manual!! There is no function to do what you need.
To do this manually, you will be creating a table of the initial record column values. They will all need to be the same data type. You cannot mix text and numeric in the formula. Either it is all text or all numeric.
The following formula would convert the record you have shown into a table with a Name and Value column for each row.
With({_rec: yourRecordhere},
Ungroup(
Table({Name: "amount", Value: Text(_rec.amount)},
{Name: "amountGBP", Value: Text(_rec.amountGBP)},
...etc...
),
"Name"
)
)
I hope this is helpful for you.
MS.Ragavendar
32
Michael E. Gernaey
24
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional