24
Hi,
I'm having issues with something i really did not think i would have any issues with: I simply want to add 3 single-column collections to each other like this:
Instead of getting the values from the single-column collections in a joined column, I keep getting entire collections in a single cell.
This seems to be a very simple task, but after looking at other threads I can't find a solution that works for me.
Any help would be much appreciated
This will work only if the three collections are exactly the same number of rows:
Share
Report
All responses (
Answers (
Clear(colTogether);
ForAll(
Sequence(CountRows(collection1)) As index,
Collect(colTogether,
{
Column1: Last(FirstN(collection1, index.value)).value,
Column2: Last(FirstN(collection2, index.value)).value,
Column3: Last(FirstN(collection3, index.value)).value
}
)
);
Hope that helps,
Bryan
